title: Multiple conditions (equal & like ) on the same column with conditions in another column SQL Server
body: <p>Problem is how to put both <code>like</code> or "equal" conditions in one column with mixing the others conditions in different columns </p>
  
  <p>My goal:</p>
  
  <pre><code>select *
  from TABLE
  where A_column like 'A%' 
    and B_column = '5' 
    and C_column like 'SH%' or = 'SY_0005'    -- like &amp; equal in one column
  </code></pre>
  
  <p>I cannot use <code>REGEX_LIKE</code> by just doing:</p>
  
  <pre><code>select *
  from TABLE
  where A_column like 'A%' 
    and B_column = '5' 
    and REGEXP_LIKE(C_column, '^(SH|SY_0005)')
  </code></pre>
  
  <p>What is the equivalent way to perform it in SQL Server?</p>