title: Check valid phone number in SQL Server
body: <p>I am trying to check if the phone numbers in the table are in the proper format or not. If not I want it to move to another column.</p>
  <p>Invalid phone numbers are:</p>
  <ul>
  <li>Less or more than 10 digits (numbers only)</li>
  <li>Number that has alphabet or special characters (except () -)</li>
  </ul>
  <p>Sample input:</p>
  <pre><code>phoneNumber
  --------------
  +1(111)11-1111
  1111111111
  11(11)111111
  11abcd1111
  </code></pre>
  <p>Expected result:</p>
  <pre><code>phoneNumber
  ---------------
  +1(111)11-1111
  1111111111
  </code></pre>
  <p>I wrote this query but it doesn't seem to work</p>
  <pre><code>SELECT PhoneNumber
  FROM Customers
  WHERE PhoneNumber LIKE '[(][0-9]{3}[)]\s[0-9]{3}[-][0-9]{4}'
  </code></pre>