Welcome, Guest
by pankaj on Thursday, 23 July 2009
Splitting Full name data to First, Last(In sqlserver)
select name,
substring(name,1,charindex(' ', name)-1) FirstName,
substring(name,charindex(' ', name)+1,len(name)) LastName
from provider
|
My Blog Title
|