Home Forums Data Warehousing Data Transformation Services (DTS) break up a NAME col into FNAME, LNAME cols RE: break up a NAME col into FNAME, LNAME cols
Frank Kalis
SSC Guru
Points: 111183
More actions
November 13, 2003 at 4:36 am
#481821
This is a cross post!
I think Jonathan gave an excellent solution here
http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=18145&FORUM_ID=8&CAT_ID=1&Topic_Title=Break+up+full+name+col+into+fname%2C+lname+cols&Forum_Title=T%2DSQL
Frank
http://www.insidesql.de
http://www.familienzirkus.de
--Frank KalisMicrosoft SQL Server MVPWebmaster: http://www.insidesql.org/blogsMy blog: http://www.insidesql.org/blogs/frankkalis/[/url]