Use the Value Lookup window to find appropriate values for a search
condition. You do this by finding values that currently exist in the
table column to be searched. The table column is selected in the
Condition page of the SQL Assist SmartGuide. You can use the Value
Lookup window to look for values in the table column that include a specific
character string or you can display all the values in the table column.
Fields
- Search for identifies a character string to search for in the
table column. If nothing is entered in this field, the value search
returns all values in the table column. The % character is a wildcard
character. For example, specifying A% searches for values that begin
with the character A. Specifying %1 searches for values that end with
the character 1. The specification A%1 searches for values that begin
with the character A and end with the character 1.
- Maximum hits specifies the maximum number of values that can be
returned in the value search. The default is 25
- Case sensitive is a checkbox. If checked, the search is
case sensitive; the search for values is based on the upper or lower case of
the character string in the Search for field, exactly as entered. If
the checkbox is not checked, the search for values in not case sensitive; the
search for values must match the character string in the Search for field but
can be any combination of upper or lower case.
- Available values lists the values in the table column that meet
the criteria specified in the Search for field.
Push buttons
- Find now searches the specified table column for values that
contain the character string specified in the Search for field. If no
character string is specified, all values in the column are returned.
- Use values adds values selected in the Available values list to
the Values list in the Condition page of the SQL Assist SmartGuide.
- Close closes the Value Lookup window.
Specifying Search Conditions
