Magic xpa SQL Functions (Magic xpa 4.x)

Magic xpa SQL is similar to the SQL Where Range. Unlike the SQL Where Range, which can use any free form text, the Magic xpa SQL Where range is limited to expressions that the Magic xpa engine can translate to SQL.

The following expressions can be used in a Magic xpa SQL Where Range:

**Cannot be used in the Magic xpa SQL Where Range if the database is SQLite.

***Not supported when used in the Magic xpa SQL Where if the database is SQLite.