Home Forums SQL Server 2008 SQL Server Newbies Split a name on to new columns in a table RE: Split a name on to new columns in a table

  • August 28, 2012 at 6:25 am

    #1530750

    amarkhowe (8/28/2012)

    Yes they would be so example:

    Full Name

    MR Peter ASHWORTH

    would end up as

    Full Name TitleFirst NameLast Name

    Mr Peter ASHWORTHMrPeter ASHWORTH

    Cheers

    What's the name of your table? What are the names of the columns for the three new data elements?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden