< > <= >= <> = AND OR NOT IS [NOT] NULL [NOT] LIKE [NOT] IN ( [,...] ) [NOT] BETWEEN x AND y [conditional] ANY ( [,...] ) [conditional] ALL ( [,...] ) AVG | MAX | MIN | SUM | COUNT GREATEST|LEAST(x,y,...) <{ROUND|TRUNC<!ATE>}({x,places|date,format})> POSITION( s1 IN s2) EXTRACT( datetime FROM datetime_value) CHAR_LENGTH( s1 ) <LENGTH( s1 )> SUBSTRING(string FROM start [FOR length])|<SUBSTR(string,