[ Just Copy & Paste ]
declare @TBL table(EmployeeName varchar(100))
insert into @TBL(EmployeeName)
values('Manish Pathak'),('Raj Kumar'),('Rakesh Singh'),('Suresh Panday'),('Anil Kare')
select
EmployeeName as 'FullName',
SUBSTRING(EmployeeName,1,PATINDEX('% %',EmployeeName)-1) as 'FirstName',
SUBSTRING(EmployeeName,PATINDEX('% %',EmployeeName),LEN(EmployeeName)) as 'LastName' from @TBL
No comments:
Post a Comment