Answer:
create table splitS(FullName NVARCHAR(50))
select LEFT(fullname, CHARINDEX(' ', fullname + ' ') -1),
STUFF(fullname, 1, Len(FullName) +1- CHARINDEX(' ',Reverse(fullname)), '')
from splitS
insert into splitS values('ASWINI ALURI')
Asked In: Many Interviews |
Alert Moderator