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
 parsing a column to update a row

Author  Topic 

DazedAndConfused
Starting Member

5 Posts

Posted - 2011-04-12 : 08:56:45
How would I..
take column with a string 1.2.3.4.5.6 and update another column in the same row with a 4, another with 5 another with 6?

example
before procedure only column 1 has data... after column 2, column 3, and column 4 are populated

column 1 ---------------- column 2 ------column 3 ----- column 4
1.2.3.4.5.6----------------- 4 ------------ 5 -------------- 6

*--------- (used for spacing)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-04-12 : 09:05:23
you use fnParseString() from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


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

Go to Top of Page
   

- Advertisement -