Hi everyone,

I need to extract phone numbers from a dataset in Sybase IQ. The data is in the form of charcter strings which may contains special characters. For example:

#123-12345
#(001)-1221313/14
-001-123-3124/223/312

Firstly, I need to strip off non numeric characters except slashes('/'). Slashes mean replacement digits at the end of the string. I want the output to be like:

12312345
0011221313
0011221314
0011233124
0011233223
0011233312

I can handle all the special characters using replace function multiple times. But still looking for a solution to handle the slashes ('/'). I am a bit reluctant to use a while loop since it will prove to be very costly and the dataset that I am working on is huge.

Thanks
Mandeep