title: Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'Ali' to data type int
body: <pre><code>create table employee
  (
      empID int check(empID&gt;0),
      Fname varchar(50) check(Fname&lt;7),
      Lname varchar(50),
      Salary int check (salary&gt;0),
      Joining_Date date,
      DOB date, 
  
  ) ;
  insert into employee values (5,'Ali','Murtaza', 30000, '2012-01-12','1984-01-20')
  </code></pre>
  
  <p>this table gives above mentioned error..
  where as i want to have a check on Fname not to be more than 7..suggest ans please</p>