Patriot Software Solutions, Inc.

Select 

personid,

LAStmodon,

CompleteNAme,

Left(completename, Charindex(' ',completename)-1),

len(Left(completename, Charindex(' ',completename)-1)),

Right(CompleteName, len(completeName) -  Charindex(' ',completename)),

Left(Right(CompleteName, len(completeName) -  Charindex(' ',completename)),Charindex(' ',completename)-1)

From tblPeople

Where Charindex(' ',completename) > 0 

and len(completeName) -  Charindex(' ',completename) > 0

and Left(completename, Charindex(' ',completename)-1) = 

left(Right(CompleteName, len(completeName) -  Charindex(' ',completename)),Charindex(' ',completename)-1)

Order by LastModOn