Removing Delimiters 1

[bombplayer]

I have a database that I need to retrieve telephone numbers out of. The problem lies that I need these numbers with no delimiters ('-','(',etc). How can I do this?

 

[bombplayer]

And this fields are never the same where one data record could be (555) 555-5555 the next could be 555-555-5555

 

[MeanGreen]

Try this:

select replace(replace(ltrim(replace(replace(telephone,' ',''),'(','')),')',''),'-','') from table


Hope this helps.

 

[bombplayer]

Worked like a charm. Thanks so much