RE: Parse Full Name Into Last, First and Middle

SSC-Insane

Points: 20427

November 19, 2003 at 8:26 am



declare @n varchar(40)

set @n = 'Johnson Sr., John Richard'

SELECT LEFT(@n,CHARINDEX(',',@n)-1) LastName,

PARSENAME(REPLACE(STUFF(@n,1,CHARINDEX(',',@n)+1,''),' ','.'),2) FirstName,

PARSENAME(REPLACE(STUFF(@n,1,CHARINDEX(',',@n)+1,''),' ','.'),1) MiddleName

--Jonathan