Progress
Embedded SQL-92
Guide and Reference
Search Conditions
NOTE: This information on search conditions is specific to embedded SQL-92. For additional information on search conditions, see the Progress SQL-92 Guide and Reference .LIKE Predicate
Searches a character string column for a specific pattern. The search pattern is specified in a string constant or in a host variable. In the search pattern string, the underscore ( _ ) and the percent sign ( % ) have special semantics.
SYNTAX
column_name
Identifies the column to be searched for a specific pattern.
:host_variable
Identifies a C Language variable containing the search pattern.
string_constant
Identifies a string constant containing the search pattern.
NOTES
- A column_name specified in the LIKE predicate must be of data type CHARACTER or data type VARCHAR.
- A host_variable specified in the LIKE predicate must be a character string variable.
- Use the ESCAPE clause to escape the special semantics given to the underscore ( _ ) and percent ( % ) characters.
- The escape character must precede each special character in order to disable its semantics.
IN Predicate
Compares a value against a set of values.
SYNTAX
expression
Identifies the value to be compared with a set of values.
query_expression
Indicates that the expression is to be compared with the single column value returned in the result set of a query_expression. Note that a query_expression in this context must be enclosed in parentheses.
( { host_variable | constant } [ , ... ] )
Is a comma-separated list of one or more variables and constants against which the expression is to be compared. Note that the entire list must be enclosed in parentheses.
NOTE
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |