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)
 Need Help to split First Name and Last Name

Author  Topic 

TMDOSS
Starting Member

33 Posts

Posted - 2009-04-20 : 11:47:11
I have a colum which has last_name , firstname
I need to split these values into last_name and firstname
Pl help

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2009-04-20 : 11:54:39
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56499

"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2009-04-20 : 13:14:29
Latest version:
http://sqlblindman.pastebin.com/f68f37c15

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page
   

- Advertisement -