itBoolean

Accepts a boolean word. Matching is case-insensitive.

Accepted words

Meaning	Accepted input
True	true, t, yes, y, sim, s, verdadeiro, v
False	false, f, no, n, nao, não, falso

Any other input returns ERR_INVALID_FORMAT.

Values[]

Contains True or False (Delphi BoolToStr canonical form), regardless of the original input word.

SQLValues[]

The SQL literal depends on the dialect.

Dialects	True	False
sqlMySQL, sqlElevateDB, sqlDBISAM, sqlPostgreSQL, sqlFirebird, sqlBDEParadox	TRUE	FALSE
sqlMSSQLServer, sqlSQLite, sqlOracle	1	0
sqlAccess	True	False

List and range

Boolean lists and ranges are supported syntactically, though they are rarely meaningful in practice. No order check is applied to boolean ranges.

Input: true;false   →   otList, SQLExpression (ElevateDB): IN (TRUE, FALSE)