Database Tour Documentation
Filter Examples

1. Select records from the table payments where values of the numeric field PAYSUM are greater than 400 and less than 2000:

PAYSUM > 400 AND PAYSUM < 2000

2. Select records from the table books where values of the numeric field COST are greater than 150:

COST > 150

3. Select records from the table goods where values of the numeric field COST are not equal 150, and values of the string field NAME match to Tea or Coffee:

cost <> 150 and (Name = 'Tea' or Name = 'Coffee')