Notes

  1. 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.
  2. 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.
  3. 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.
  4. 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 ]