Hi Ng,
i have in my db round about 5000 phone numbers in the manner
[prefix]-[number]
[prefix] [number]
[prefix]/[number]
and maybe some other cases.
i have a telecom system, who gives me the numer like
[prefix][number] (without any other characters)
how can i search in my db to find the right record ?
one solution can be to make a second field without any characters except
0-9 and then serach this second field, but this is not perfect.
Hans
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]