General information
Forum:
Microsoft SQL Server
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only