CharIndex Help

  • Help, I just learned about this charindex function but I can't seem to get it to work.

    I have a name field 'Jimenez, Laura @' and I need to make 2 columns one with the first name and one with the last name and ignore all symbols attached to the name. I got part of it to work but don't know enough to finish it 🙁

    SUBSTRING(TPSAptfor,(CHARINDEX(',',TPSAptfor,1)+1),???) For the first name

    SUBSTRING(TPSAptfor,1,CHARINDEX(',',TPSAptfor,1)-1) get errors for the last name

    Thanks for any help

  • please do not cross-post.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Sorry thought I had deleted the first one

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply