How to print the value with desired text in TSQL using sql server 2005

Question

I want to select a value from my customers datatable. I have been asked this question in an interview.

Select cust_Name from customers where cust_Id=5;

will result as Naresh.

Now I want to print the value as

Customer Name is Naresh

How can I print the value like this.Thank you

Answer 1

You can use concat()

Select concat('Customer Name is',cust_Name) as values from customers where cust_Id=5;

Click here to learn more about concat()

Answer 2

Select 'Customer Name is ' + cust_Name from customers where cust_Id=5;

Or

Declare @CustomerName varchar(50)
Select @CustomerName = cust_Name from customers where cust_Id=5;
Print 'Customer Name is ' + @CustomerName ;