title: How to print the value with desired text in TSQL using sql server 2005
body: <p>I want to select a value from my <code>customers</code> datatable. I have been asked this question in an interview.</p>
  
  <pre><code>Select cust_Name from customers where cust_Id=5;
  </code></pre>
  
  <p>will result as <code>Naresh</code>.</p>
  
  <p>Now I want to print the value as</p>
  
  <pre><code>Customer Name is Naresh
  </code></pre>
  
  <p>How can I print the value like this.Thank you</p>