Hi Friends...
Today I am going to show you how to concatenate two columns in sql server
Suppose you have a table tblDemo which have two columns like first_name and Last_name . If you want to concatenate these two columns with a space then write this query
1. select first_name + ' ' + Last_name from tblDemo
2. select first_name + ' - ' + Last_name from tblDemo
Thank You !
Today I am going to show you how to concatenate two columns in sql server
Suppose you have a table tblDemo which have two columns like first_name and Last_name . If you want to concatenate these two columns with a space then write this query
Your Queries are as under
1. select first_name + ' ' + Last_name from tblDemo
2. select first_name + ' - ' + Last_name from tblDemo
Thank You !
0 comments:
Post a Comment