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.
[ Previous Page | Next Page | Contents | Index ]