return numbers only in SELECT query? 1

[admoore]

I have a query that includes a VARCHAR field with phone numbers formatted in a variety of ways, i.e. 999-555-1212, (999) 555-1212, etc...

Can a select query return only the numeric data in the record, in this case 9995551212 ?

TIA,

-Allen M.

 

[r937]

sure, but you have to use the REPLACE function to replace those characters with null strings

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[admoore]

I actually opted to fix the data before selecting it...

UPDATE teble SET phone = REPLACE(phone,'-','');