2.14.5 Control Flow Functions and Operators

The following table shows supported control flow operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 2.8.1, “Encoding String Columns”.

Table 2.5 Control Flow Functions and Operators

Name	VARLEN Support	Description
CASE	Yes	Case operator
IF()	Yes	If/else construct
IFNULL()	Yes	Null if/else construct
NULLIF()	Yes	Return NULL if expr1 = expr2