search without some special characters

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