title: Use of pipe symbol in Select clause
body: <p>Is there any way/use of putting pipe symbol <code>||</code> in <code>select</code> clause.</p>
  
  <p>I have come across following query in one of the article(probably to concatenate two values), but when I try to use the same in my query I am getting syntax error.</p>
  
  <pre><code>select FirstName ||''|| LastName As CustomerName from Customer
  </code></pre>
  
  <p>Please correct if I am using wrong syntax.</p>