I have a table of locations. For any given ctrl number, I need to determine if there are any active locations in a particular state for a particular version. The version number reflects the version in which the latest activity took place. In looking at the table below, I want to determine if there are any active records for CA.

 ctrl  locat_num  version   deleted   state
 42910     1         0        F        MT
 42910     2         0        F        MT
 42910     3         2        F        CA
 42910     3         3        T        CA

Version 0 should return FALSE (only MT locations)
Version 1 should return FALSE (only MT locations)
Version 2 should return TRUE (one CA location)
Version 3 should return FALSE (CA location was deleted)

I can do this in two queries

FUNCTION hasState
PARAMETERS tnCtrl,tnVersion,tcState

SELECT locat_num,MAX(version) AS version ;
  FROM myTable;
 WHERE ctrl = tnCtrl AND version <= tnVersion AND state = tcState;
 INTO CURSOR curXXX

SELECT * FROM myTable mm,curXXX xx;
 WHERE mm.ctrl = tnCtrl;
   AND mm.locat_num = xx.locat_num;
   AND mm.version = xx.version;
   AND NOT mm.deleted

llReturn = _TALLY > 0

I'd like to get this down to one query, but can't quite get a grasp on how to do it. Any help would be appreciated.

Thanks..........Rich