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
 want to Colunm

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2007-03-15 : 10:50:14
Afternoon all,

I have a colunm sName(nVarChar(255) which has first name and second name in it and is divended with a ",". Can somebody show me to put these in there own colunm sFirstName and sSecondName.

Very Kind regards.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-03-15 : 10:56:06
Take a look here for various code to split strings
http://sqlteam.com/forums/topic.asp?TOPIC_ID=50648
Go to Top of Page
   

- Advertisement -