Enhanced Query Syntax

To match the data retrieval functionality supported by Magento, the Simba Magento ODBC Driver supports queries that combine the NOT operator with other operators.

For example:

SELECT * FROM Schema.TableName WHERE NOT Column_Name1 IN ('Simple_Value1', 'Simple_Value2', 'Simple_Value3')

SELECT * FROM Schema.TableName WHERE NOT Column_Name1 LIKE 'Simple%Value%'

SELECT * FROM Schema.TableName WHERE NOT Column_Name1 IS NULL