Execute SQL looking for Empty and not Empty

[archrid404 0]

Hello, What's the proper format to when looking for empty and not empty information?

[comment 1,777]

Here are two examples from the  FileMaker16 SQL Reference document (which should always be the first place to look):

SELECT Sales_Data.Amount FROM Sales_Data WHERE Sales_Data.Amount IS NULL

SELECT Sales_Data.Amount FROM Sales_Data WHERE Sales_Data.Amount IS NOT NULL