Help : How to manage stars in database ?

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:
> 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 !
>

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