concatenate two columns in the result set in SQL Server

    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/