MapInfo - Simple SQL test to see if field populated

Description:
Video #42
This very short video (a smidgen over 1 minute) demonstrates the very simple SQL needed to see if a field has any data in it or not.
The SQL reads like this:

select * from //mytable// where AMENITY

... that would show all records where that field 'AMENITY' is populated e.g. parking, courthouse.

By simply using:

select * from //mytable// where NOT AMENITY

...returns all those records where the AMENITY field is NOT populated.

Hope thats useful :)