title: Adding upper case letter only constraint in SQL Server
body: <pre><code>create table EmployeeStatistics  
  (  
       EmployeeIdNo int,  
       Name varchar(30),  
       Salary integer,  
       Benefits integer,  
       Position varchar(25),  
       Allowance integer,   
       DateOfBirth integer,  
       Telephone integer,     
       primary key (EmployeeIdNo)  
  );
  </code></pre>
  
  <p>I want <code>Position</code> to accept only upper case letters. Which constraint to add?</p>
  
  <pre><code>alter table EmployeeStatistics
  #add constraint
  </code></pre>