Removing characters and spaces from a field

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Removing characters and spaces from a field

Author

Topic

waxdart23
Starting Member

33 Posts

Posted - 2005-06-08 : 04:14:36

I am currently trying to convert some phone number data which has been entered with spaces for formatting and in some cases with text. Is there a way of removing all spaces and text from this field leaving just the numbers?

Thanks

Thanks
P

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-06-08 : 04:19:43

without sample data and ddl, you can use replace (search and read bol)

--------------------
keeping it simple...