title: Can the Select list in a SQL Statement use Regular Expressions
body: <p>I have a SQL statement,</p>
  
  <pre><code>select ColumnName from Table
  </code></pre>
  
  <p>And I get this result,</p>
  
  <pre><code>Error 192.168.1.67 UserName 0bce6c62-1efb-416d-bce5-71c3c8247b75 An existing ....
  </code></pre>
  
  <p>So anyway the field has a lot of stuff in it, I just want to get out the 'UserName'.</p>
  
  <p>Can I use a regex for that?</p>
  
  <p>I mean it would be kind of like this,</p>
  
  <pre><code>select SUBSTRING(ColumnName, 0, 5) from Table
  </code></pre>
  
  <p>Except the SUBSTRING would be replaced with a regex of some kind. I am comfortable with regex, but I am not sure how to apply it in this case, or even if you can.</p>
  
  <p>If I could get this working it would be great because I plan to pull the data into a temporary table, and do some quite complicated things matching it with other tables etc. If I can get this all working it would save me writing a C# app to do it with.</p>
  
  <p>Thanks.</p>