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
 Separate A Column Into Many

Author  Topic 

Weekend
Starting Member

20 Posts

Posted - 2007-07-19 : 05:15:47
Hi

I have a column say “Col_1” in which “=>” is used as separator.
Col_1 data is as follows
House => Street => Area => City => Country =>

I want to create separate columns for House, Street, Area etc from Col_1 using “=>’ separator.

Please advise how?

Thanks
Jawad


khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-19 : 05:17:42
use a split / parse function here. Take your pick.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830&SearchTerms=CSVTable
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


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

Go to Top of Page
   

- Advertisement -