title: How to extract phone number from varchar column in SQL Server?
body: <p>I have a <code>varchar</code> column in my table which can contain phone numbers in different formats along with some text in there.   </p>
  
  <p>Examples:    </p>
  
  <pre><code>"This is a test 111-222-3344"  
  "Some Sample Text (111)-222-3344"  
  "Hello there 1112223344 . How are you?"
  </code></pre>
  
  <p>How do I extract the phone numbers from this? I've looked up other solutions (<a href="https://stackoverflow.com/questions/37020663/ms-sql-how-to-extract-phone-number-from-long-inconsistent-string">Another Post</a>), but they don't fit my requirements. </p>
  
  <p>Thank you</p>