OK, OK --- Ya got me ... and Zahid had a good idea about placement of the options.

>>Hey all. Simple test of the "doh!" principle here: The question is 'What will end up being printed on the screen?' .. Yes, I know the answer - just testing y'all :-)
>>
>>And, no, it's not the GenPrimary() UDF
>>
>>

>>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"