NOT

Retrieves rows that contain different values from the specified data. Can be used with operators <, >, = to collect specific rows.

 

Example:

SELECT * FROM Customers_dataflex WHERE customerstate is NOT = 'UT'