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