Tuesday, February 15, 2011

How to break the FullName of a Employee into First & Last Name

[ 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