>>SET STRICTDATE TO 0 >> >>SELECT MAX(flocknum) FROM ; >>(SELECT SUBSTR(fm_flcode,5,4) flocknum ; >>FROM flckmast ; >>WHERE fm_hatched <= {4/1/07} ; >>AND fm_hatched >= {3/1/07} ; >>) ; >>INTO CURSOR test >>>>
>SELECT max(SUBSTR(fm_flcode,5,4)) ; > FROM flckmast ; > WHERE fm_hatched between date(2007,3,1) and date(2007,4,1) ; >INTO CURSOR test >>Cetin