WHERE ----- f1 = / != / <> 50; f1 BETWEEN 20 AND 50; f1 IN ('hans', 'fritz', 'anna'); f4 LIKE'Ha%'; (case sensitive!) % und weitere, auch keine Chars _ substitute 1 char f4 IS NULL; f4 IS NOT NULL; WHERE (cond1 AND cond2) OR (cond3 NOT cond4);