Help : How to manage stars in database ?

[MaisonBorniol]

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 !

[Hieu Hoang]

Post by MaisonBorniol
All,
Any help would be gratefully appreciated.
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 !

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

[MaisonBorniol]

Thanks a lot.

It works fine under MSSQL. But what about Oracle ?

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

Post by Hieu Hoang

Post by MaisonBorniol
All,
Any help would be gratefully appreciated.
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 !

in ms sql server, use the LIKE statement. can't remember syntax, but
...
WHERE column1 LIKE '0[0-9]6666[0-9][0-9]66'
OR column1 = '005555555'
look it up in help & let me know