From: tfs@dslextreme.com   
      
   Why can I do:   
      
   SELECT PersonID = CASE WHEN o.ID  IS NULL THEN o2.ID ELSE o.ID END   
      
   SELECT PersonID = CASE WHEN o.ID IS NOT NULL THEN o2.ID ELSE o.ID END   
      
   SELECT PersonID = CASE o.ID WHEN NULL THEN o2.ID ELSE o.ID END   
      
   But not:   
      
   SELECT PersonID = CASE o.ID WHEN NOT NULL THEN o2.ID ELSE o.ID END   
      
   I get an error:   
      
          Incorrect syntax near the keyword 'NOT'.   
      
   and   
      
   SELECT PersonID = CASE o.ID WHEN IS NOT NULL THEN o2.ID ELSE o.ID END   
      
   I get an error:   
      
          Incorrect syntax near the keyword 'IS'.   
      
   Using this syntax, can I not test for 'NOT NULL'?   
      
   Thanks,   
      
   Tom   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)