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
 General SQL Server Forums
 New to SQL Server Programming
 Get Numbers Only

Author  Topic 

chriztoph
Posting Yak Master

184 Posts

Posted - 2009-06-30 : 01:46:39
hi evryone!

How can i get the numbers only or string only in a randomed string and integer value?

example:
'chr32iz73toph'

the output should be like this:
'3273'
OR
'chriztoph'

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-30 : 01:55:27
see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79083


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-30 : 04:01:19
Also refer
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -