title: Sql Like to RegEx
body: <p>Is there a good way to convert Regular Expression into LIKE inside a Function (MSSQL)? 
  The sproc does not get more complicated than this:</p>
  
  <pre><code>(country\=)(?&lt;Country&gt;[\w\d]+)(\&amp;sessionid\=)(?&lt;SessionId&gt;.+)
  </code></pre>
  
  <p>The groups will not be used in the LIKE, they are there for another purpose.</p>
  
  <p>I would like to use this inside a sproc late like:</p>
  
  <pre><code>SELECT * FROM [Table]
  WHERE test_regex(regex, 'text') = 1
  </code></pre>
  
  <p>Where the regex is a part of [Table]</p>