The following example scans the orders
table for all records in the order_amt
field with values between 950 and 1000 inclusive and displays the cust_id
field and the order_amt
field.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE orders && Open order table
CLEAR
SCAN FOR BETWEEN(order_amt,950,1000)
? cust_id, order_amt
ENDSCAN