MapInfo - Simple SQL test to see if field populated

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 :)