>Does anyone know if sql server has a string function that works like VFP's strtran()?
>I have a table with a phone_number column that has data such as
>(123)123-4567
>223-123-4567
>
>I want to remove any non number character so I wind up with
>1231234567
>2231234567
>
>I'm pouring thru my sql books, but have yet to find something.
>Any suggestions would be greatly appreciated.
>
>Thanks,
>-Isaac

Look at REPLACE() function in SQL books online.