Split out FirstName, LastName, MiddleName

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  December 5, 2013 at 12:36 pm

  #287106

  One column name as [MemberName] in which stored data like

  LastName, FirstName M (with initial middle name)

  or

  LastName, FirstName (without initial middle name)

  How to create a function to split out two columns [First name] and [Last name]?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  December 5, 2013 at 12:44 pm

  #1671297

  Something like this?

  WITH CTE([MemberName])AS(

  SELECT 'Cazares, Luis' UNION ALL

  SELECT 'Cazares, Luis A')

  SELECT LEFT( MemberName, CHARINDEX(',', MemberName) - 1) LastName,

  SUBSTRING( MemberName, CHARINDEX(',', MemberName) + 1, LEN( MemberName)) FirstName

  FROM CTE

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  December 5, 2013 at 12:53 pm

  #1671300

  Thank you for help.

  We are getting there but if MemberName is 'Cazares, Luis A' I want to display as 'Cazares, Luis' as well.

  How modify code?