Вы можете использовать функцию разделения.
SELECT (select top 1 item from dbo.Split(FullName,',') where id=1 ) as Name, (select top 1 item from dbo.Split(FullName,',') where id=2 ) as Surname, FROM MyTbl