title: How to code the NOT IN query in Hibernate criteria?
body: <p>This is the query that I am trying to write in Criteria:</p>
  
  <pre><code>    SELECT * FROM abc 
      WHERE NOT PartType IN ('0','4','5','6','7','a','b','c') 
  </code></pre>
  
  <p>The above is in iBatis.</p>
  
  <p>So this is the hbm.xml for the table</p>
  
  <pre><code>  &lt;class name="Parts" table="SomeDb..Parts"&gt;
          &lt;id name="recordNumber" column="Recnum" /&gt;
          &lt;property name="partNumber" column="Partnum" /&gt;
          &lt;property name="sectionNumber" column="Secnum" /&gt;
          &lt;property name="articleNumber" column="Articlenum"/&gt;
          &lt;property name="headerNumber" column="Headernum"/&gt;
          &lt;property name="partType" column="PartType"/&gt;
          &lt;property name="code" column="Code"/&gt;
    &lt;/class&gt;
  </code></pre>
  
  <p>The partType is nvarchar with the length of 1 in a SQL Server db.
  I am trying to select records that do not have a part type of any of this '0','4','5','6','7','a','b','c'.
  Hope I have answered your question.
  Thanks</p>