UltraLite Database User's Guide
Dynamic SQL
Dynamic SQL language elements
Search conditions appear in the WHERE clause or the ON phrase in SQL queries. The following search conditions are supported in dynamic SQL.
search-condition:
expression compare expression
| expression IS [ NOT ] { NULL | TRUE | FALSE | UNKNOWN }
| expression [ NOT ] BETWEEN expression AND expression
| expression [ NOT ] LIKE expression
| expression [ NOT ] IN ( expression, ... )
| NOT search-condition
| search-condition AND search-condition
| search-condition OR search-condition
| ( search-condition )