Home Forums SQL Server 7,2000 T-SQL PARSE FULL NAME INTO LASTNAME,FIRSTNAME, MI RE: PARSE FULL NAME INTO LASTNAME,FIRSTNAME, MI

  • Lowell (1/13/2010)


    that would occur if any space existed in the last name, before the slash.

    a name like Mac Bride/Bob Lee would make that happen... you'll need to tweak it based on your data.

    from your example, i assumed the only space was between first and middle names.

    The lack of a slash would cause that error as well...

    Seems like it's going to be quite a bit of work to get all the special patterns covered...

    But that's the price one has to pay when dealing with (over-)denormalized data, I guess...



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]