Related Posts Plugin for WordPress, Blogger...

About

Follow Us

Monday, 2 February 2015

 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 "

Categories:

0 comments:

Post a Comment