title: How to use collate in a constraint?
body: <p>I need to add a constraint to input specific sample data in uppercase to a column named <code>State</code> . this is what i tried. but it returns error message "Incorrect syntax near the keyword 'COLLATE'."</p>
  
  <pre><code>ALTER TABLE [Client]
  ADD CONSTRAINT [client_statecheck]
  CHECK COLLATE  SQL_Latin1_General_CP1_CS_AS (State in('QLD', 'NSW', 'VIC','TAS', 'SA', 'WA', 'NT', 'ACT' ));
  </code></pre>