Sorry... won't work...

Your select statement will choose the last record that has a higher value than 99.


SELECT IIF(nfield>99, nfield, 99) FROM ....

SELECT MAX(nField) FROM ... WHERE nField > 99

IF _TALLY = 0
nField =99
ELSE
nField = result.nfield
endif