• 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 Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]