title: Get T-SQL value using Regular Expressions
body: <p>I have the following string in database:</p>
  
  <pre><code>SET @Value = "[4888378977CA4A5] Test String"
  </code></pre>
  
  <p>Also, the <code>@Value</code> may also have 'RE: ' at the start of the string such as:</p>
  
  <pre><code>SET @Value = "RE: [4888378977CA4A5] Test String"
  </code></pre>
  
  <p>How can I access the <code>4888378977CA4A5</code> part of the string using regular expressions?</p>
  
  <p>Thanks!</p>