Notes
- When searching for data with a specific ending, be aware of
the data type of the column you are searching. If the column has
a fixed width and the data in the column varies in width, use a
trailing percent sign to represent any blanks that might follow
your search criteria. If the column you are searching has a data
type of VARCHAR, there are no trailing blanks.
- When you are in SEARCH mode, enter your search criteria
and press the SEARCH function key to retrieve rows whose columns
match your search criteria.
- To search for data when you know only part of a value, use either
or both of the following symbols in your search criteria as wildcards
for locating patterns;
- % (percent)
- Represents a position in the string containing any number
and combination of characters, including no characters at all.
- _ (underscore)
- Represents a position in the string that must contain exactly
any one single character.
- You can use both % and _ in the same value. Each can
be used multiple times. For example, using a pattern of _OS% as
your search criteria might find a match with the column values of
ROSS, DOS or BOSLEY.
