SQL Operators

SQL operators are used to specify comparisons between expressions.

Operator	Description
BETWEEN	Determines if a value is between two non-inclusive bounds. For example: "COSTS"."UNIT_COST" BETWEEN 100.0 AND 5000.0 BETWEEN can be preceded with NOT to negate the condition.
IN	Determines if a value is present in a set of values. For example: "COSTS"."UNIT_COST" IN(200, 600, 'A')
IS NULL	Determines if a value is null. For example: "PRODUCTS"."PROD_NAME" IS NULL
LIKE	Determines if a value matches all or part of a string. Often used with wildcard characters to indicate any character string match of zero or more characters (%) or a any single character match (_). For example: "PRODUCTS"."PROD_NAME" LIKE 'prod%'