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