to split a FullName into different parts. RRS feed

  • Question

  • Hi All,

    I have a column(FullName) which has the fullname of a person separated by spaces.
    I  have to split them as per their Firstname, Middlename,Lastname,suffix.
    Some have only firstname ,few with both firstname and lastname,few with 3 fields and few with 4 fields.

    Is it possible to split them into 4 parts by writing a SQL Query.

    Lawrence Wright III
    Brenda Castillo
    Ann  R  Williams
    Suman M Gupta Jr

    Majority of them in the column have firstname and lastname.

    Thanks in Advance.

    Thursday, March 18, 2010 10:06 PM