title: Create rule to restrict special characters in table in sql server
body: <p>I want to create a rule to restrict special characters to be entered into a column.
  I have tried the following. But it didnt work.</p>
  
  <pre><code>CREATE RULE rule_spchar
  AS
  @make LIKE '%[^[^*|\":&lt;&gt;[]{}`\( );@&amp;$]+$]%'
  </code></pre>
  
  <p>I dont know what I am doing wrong here. Any help would be appreciated.</p>