Home Forums SQL Server 2008 SQL Server Newbies Breaking up a string of text RE: Breaking up a string of text

  • September 24, 2013 at 2:52 pm

    #1652892

    try

    select

    substring( lastname, charindex(',', lastName )+1,

    (charindex (',', lastName, charindex(',', lastName )+1 )-

    charindex(',', lastName ))-1

    )