How to concatenate two columns in the result set in SQL Server?
It's too simple. Check the below script,
drop table venkat_table
go
create table venkat_table (id int,val varchar(100),val1 varchar(100))
insert into venkat_table values(1,'Venkat','Prabu')
select ID, val +' '+ val1 as name from venkat_table Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/