Core functions

Devart ODBC Driver for xBase supports the following core SQL functions.

Function	Description
`IIF(X, A, B)`	Evaluates expression `X`. If it is `True`, returns `A`; otherwise, returns `B`.
`EMPTY(X)`	Returns `True` if expression `X` is considered empty. Character and date expressions are empty if they contain an empty string. Numeric expressions are empty if they evaluate to `0`. Logical expressions are empty if they evaluate to `False`.
`FSIZE(F, T)`	Returns the size, in bytes, of field `F` in table `T`.
`NOT(X)`	Returns `True` if expression `X` evaluates to `False`; otherwise, returns `False`.
`BITTEST(X, N)`	Returns `True` if the `N`-th bit of integer `X` is set to `1`; otherwise, returns `False`.

Note

Devart ODBC Driver for xBase is powered by the SQLite engine, therefore the driver also supports the full set of core SQL functions supported by Devart ODBC Driver for SQLite.