title: SQL Server command LIKE [0-9] won't match any digit between 0 and 9
body: <p>This is the constraint I have on the Customers table.</p>
  
  <pre><code>ALTER TABLE Customers
      ADD CONSTRAINT CN_CustomerPhone
      CHECK (Phone LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]')
  </code></pre>
  
  <p>Why does this fail?</p>
  
  <pre><code>INSERT INTO Customers
  (CustomerName, Address, City, State, Zip, Phone)
  VALUES
  ('Some Name','An Address', 'City goes here', 'WI', 12345, '(800) 555-1212')
  </code></pre>
  
  <p>With this error message.</p>
  
  <blockquote>
    <p>Msg 547, Level 16, State 0, Line 1 The
    INSERT statement conflicted with the
    CHECK constraint "CN_CustomerPhoneNo".
    The conflict occurred in database
    "Accounting", table "dbo.Customers",
    column 'Phone'. The statement has been
    terminated.</p>
  </blockquote>
  
  <p>I'm sure I'm missing something really simple, but I can't find it.</p>
  
  <p>I've tried simplifying the constraint to only 'Phone LIKE '[0-9]'' and inserting a single digit, but it still fails. WTF?</p>