>OPEN DATA foomeister >CREATE TABLE foo (pk C(30) PRIMARY KEY,amount N(10,2),quantity N(4,0)) >INSERT INTO foo (pk,amount,quantity) VALUES (GenPrimary(),100.15,1) >SELECT * FROM foo WHERE amount > 200 INTO CURSOR foobaby >SELECT foobaby >DO CASE >CASE foobaby.amount = 0.00 > ?"No Sale" >CASE RECCOUNT('foobaby') = 0 > ?"No records" >CASE foobaby.amount <= 200 > ?"Small spender" >ENDCASE"No Sale"