|
 
| |
Selected Records
Fields
Field
Key in the search field code (examples at the bottom or your screen)
Test Field
- NE - Not equal
- GT - Greater than
- LT - Less than
- GE - Greater than or equal to
- LE - Less than or equal to
- RANGE - Range (between Value1 and Value2, or
equals a value)
- IS - NULL
- ISNOT - NULL
- LIST - List (field equals Value1, or equals Value2,...)
- NLIST - Not list (field does not equal Value1, or....)
LIKE - Like (field starts with, ends with, or matches the pattern in Value)
- NLIKE - Not like (field does not start with, does not end
with, or does not match the pattern in
Value
- Numeric constants:
TEMP LT -40
AGE RANGE 16 65
- SBCS character constants:
LASTNAME EQ 'Peterson'
STORENAME LIST 'DALLAS' 'CHICAGO' 'LONDON'
LOCATION NLIST 'TEXAS' 'ILLINOIS'
- DBCS character constants:
TAG GE '<AA>' (DBCS-only)
TEXT EQ '<AA>ABCdef123' (DBCS-open)
TEXT EQ G'<AA>' (DBCS-graphic)
< and > represent DBCS shift-out/shift-in characters.
- NULL:
CITYNAME IS NULL
CITYNAME ISNOT NULL
- Date constant:
DATE EQ '1991-01-02'
- Time constant:
TIME LT '18:00:00'
- Timestamp constant:
TIMESTAMP GE '1991-01-02-18.00.00'
- Pattern values:
FIRSTNAME LIKE 'J__n' (John, Jean, Joan, ...)
LASTNAME LIKE '%son%' (Johnson, Peterson, ...)
- Dependent values:
CUSTOMER EQ :T01.CUSTNAME
|
