Not 100% certain what you are after here but take a look at this. This will parse everything into last, first, middle.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

SomeID int identity,

FullName varchar(25)

)

insert #Something

select 'DOE,JOHN' union all

select 'DOE,JOHN A'

select *

from #Something

cross apply dbo.DelimitedSplit8K(replace(FullName, ' ', ','), ',') p

You can find the code for the DelimitedSplit8K function by following the link in my signature about splitting strings.