William,

In addition to using _TALLY like the others have suggested you can do this;

SELECT * FROM Whatever INTO ARRAY laRecords
IF TYPE("laRecords(1)") <> "U"
   * You have data
ELSE
   * You have no data
ENDIF