How to Concatnate 2 column values to make one column value in SQL-Server?

 Posted by vishalneeraj-24503 on 11/26/2013 | Category: Sql Server Interview questions | Views: 914 | Points: 40
Answer:

Using '+' sign or Concat in-built function we can Concatnate 2 column values as shown below:-

select(employee_firstname + ' ' + employee_lastname) AS Name from employee_master;

select Concat(employee_firstname , ' ' ,employee_lastname) AS Name from employee_master;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response