title: Using regular expression in SQL select statement to find 11 digit numbers
body: <p>I am trying to match a regular expression using SQL where I can return the details of only accounts whose AccountNumber is an 11 digit. I have used the following but it does not seem to be working:</p>
  
  <pre><code> select New_New_AccountNumber, New_PremiseNo, New_FirstName, New_LastName         
   from AccountExtensionBase
   where New_AccountNumber like '^\d{11}$'
   and New_AccountStage = 7
   order by New_FirstName
  </code></pre>