title: how to give a check constraint to a character coloumn
body: <p>How can i give a check constraint to a column whose datatype is char(1)</p>
  
  <p>coloumn name--->group<br>
  datatype------->char(1)</p>
  
  <p>CHECK(c,s,a)</p>
  
  <p>plz tell me the exact query how to insert it into sqlserver2005 while creating a table,, in which group is a column...</p>
  
  <p>Thanks,
  Churchill</p>