Try this
Declare @t table(Id int identity,FName varchar(10),LName varchar(10),Location varchar(10))
Insert into @t
Select 'Raghu','Goud','Hyd' Union All
Select 'Suchi','Sake','Atp'
-- For all version of Sql Server
Select
Id
,ConcatName = FName + LName
,Location
From @t
-- Denali(Sql 11) Ctp 3 specific
Select
Id
,ConcatName = Concat(FName,LName)
,Location
From @t
Output
-----------
Id ConcatName Location
1 RaghuGoud Hyd
2 SuchiSake Atp
Let me know if this helps
Thanks
Best Regards,
Niladri Biswas
Rrana, if this helps please login to Mark As Answer. | Alert Moderator