title: Use a condition while creating a table in SQL
body: <p>I'd like to create a table with a condition</p>
  
  <pre><code>create table TOTO
  (
      Id int not null, 
      zip  as (if(zip &gt; '00999' and zip &lt; '96000') then zip) ,
      PRIMARY KEY (Id)
  );
  </code></pre>
  
  <p>All I get is an error message.</p>
  
  <p>Do you know how to do that with the "zip" in type char ?
  Thank you for your help !</p>