Suppose we have a
employee table having two columns First_Name having data "Mazik" andLast_Name having data "Solutions" and we want to
display the the full name as
"Mazik Solutions" in a single
field then the query will be as:
SELECT First_Name + ' ' + Last_Name as Emp_Name FROM Employee
Now Emp_Name field will have the concatenated data " Mazik Solutions "
SELECT First_Name + ' ' + Last_Name as Emp_Name FROM Employee
Now Emp_Name field will have the concatenated data " Mazik Solutions "
0 comments:
Post a Comment