title: Inserting Char value into SQL table
body: <p>I created a SQL table an enforced check constraints on it, but now when I try to insert data I get an error message.</p>
  
  <pre><code>create table BranchTel
  (
      BrRegNo varchar(10) REFERENCES Branch(BrRegNo), 
      TelNo char(12)
      PRIMARY KEY(BrRegNo)
  )
  ALTER TABLE BranchTel Add Constraint BranchTelTelNo
  Check(TelNo LIKE '[0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
  </code></pre>
  
  <p>Insert statement</p>
  
  <pre><code>insert into BranchTel values('BG-205','940112571963')
  </code></pre>
  
  <p>Error message</p>
  
  <blockquote>
    <p>The INSERT statement conflicted with the CHECK constraint "BranchTelTelNo". The conflict occurred in database "StudentDetails", table "dbo.BranchTel", column 'TelNo'.
    The statement has been terminated.
    Insert statement
    insert into BranchTel values('BG-205','94-011-2571963')
    Error message
    String or binary data would be truncated.
    The statement has been terminated.</p>
  </blockquote>
  
  <p>Please help me</p>