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 2005 Forums
 Transact-SQL (2005)
 replace characters from string

Author  Topic 

learntsql

524 Posts

Posted - 2010-03-05 : 06:22:24
Hi all,
I have string like 'Test 12 String'
Now I have to replace all the characters other than numerics from the given string.
plz tell me.
TIA.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-05 : 06:41:10
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

learntsql

524 Posts

Posted - 2010-03-05 : 06:46:25
Thank you.
Go to Top of Page
   

- Advertisement -