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)
 Difficult query to extract numbers from a colum

Author  Topic 

mr_bad_guy
Starting Member

7 Posts

Posted - 2008-08-08 : 06:15:04
The situation is as follow:

Example data

Column Address
ravenbos 90
rijpoort 36
m.vaumontlaan 22
alhons iets 27a
and so on...


What I want to do is to extract al the numbers from this column and put it in a new colomn next to it. There are around 900 records.

Does someone know howto?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-08 : 06:22:09
see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79083
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56713


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

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-08-08 : 08:22:31
or
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 -