title: SQL query with a concatenated column
body: <p>My SQL isn't that strong, I'll admit...but my query looks similar to below in MS SQL Server:</p>
  
  <pre><code>SELECT p.Product_ID as ID,
        (p.Product_Number + ' - ' +  p.Product_Name) as Name 
  FROM Product p;
  </code></pre>
  
  <p>I'm wondering, is it possible to do a query on that concatenated column? Or would I have to use two <code>WHERE</code> clauses and combine them with an <code>AND</code>?</p>