SQL Question

[Phibee Network Operation Center]

Hi

i request a small help for know if it's possible.

Anyone know if they have a Sql request for
search the best value at one information:

Sample:

i have a table with:

ID   int 5
Chaine   int 16

and this entry:

1   12345
2   123
3   12


i am search a request in "WHERE" :

Chaine LIKE '123456789' and if he don't have into the database,
he test Chaine LIKE '12345678'  etc ..
and when he arrive at 12345, he sent the ID information

thanks for your help

(PS: i use Perl for extract data)
Jerome
Sorry for my english