All,

Any help would be gratefully appreciated.

I have this trouble :

In database in one column I have record like that :
000000001
0*6666**66
005555555

Stars could be anything between '0' and '9'

So, if I look for this id : 0166662066, it would be found in database
and retrieved.

Any idea, this stuff is driving me nuts.....


Thank a lot !

MaisonBorniol wrote:
in ms sql server, use the LIKE statement. can't remember syntax, but
similar to:

....
WHERE column1 LIKE '0[0-9]6666[0-9][0-9]66'
OR column1 = '005555555'

look it up in help & let me know

Thanks a lot.

It works fine under MSSQL. But what about Oracle ?

Is there a SQL proof syntaxe for this kind of stuff ?


Hieu Hoang a écrit :