title: If value contains these letters, then
body: <p>In SQL Server, is there a way to search (and format) a result for a certain string (like <code>preg_match</code> in PHP):</p>
  
  <pre><code>SELECT (IF (col1 contains 'http'){'&lt;a&gt;' + col 1 + '&lt;/a&gt;'}
  else {'&lt;b&gt;' + col1 + '&lt;/b&gt;'}),
  col2
  FROM Table
  </code></pre>
  
  <p>... etc.</p>
  
  <p>Is this possible? I want to format the results based on their content.</p>