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

  • You can split on the slash pretty easily, but the rest is trickier. For example, will you have any names that don't have a middle name? How about ones with multiple "middle" names ("Billy Bob Sam Jones")? How about splitting names with titles in them, like Dr or Rev? Or can you be certain all the names will be in the same format?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon