For ODBC data sources and ODBC sources attached to an MS Access table, the SQL syntax supported is that of ODBC, not the native SQL version.
|
Feature |
ODBC |
non-ODBC |
|---|---|---|
|
LIKE expression single character match |
_ |
? |
|
LIKE expression substring match |
% |
* |
|
Security |
COMMIT, GRANT, LOCK |
For convenience, you can define variables such as {%} whose value will be defined in the NETBASE.INI file as "%" or "*" depending on the type of driver supported.