Written By:- Isha Malhotra (Software Developer)
Note: -if you find this article helpful then kindly leave your comment
For Asp.net Training with C# and Sql Server Click Here
When we need to concatenate the text value with the column names in this case we use + Arithmetic operator.
Check the following example:-
Suppose we want our output like this
“The Employee id of Isha Malhotra is 101”
Note: - Isha(emp_fname), Malhotra(emp_fname) and 101(emp_no)
select 'The Employee id of '+ emp_fname +' ' emp_lname + ' is ' + cast(emp_no as varchar) +'.' from employee;
in this example we used cast operator which is used to cast column in to specific datatype. As emp_no is Int type so first we have to cast it in to varchar so that we can concatenate this column with text.