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  [  NOT  ]  LIKE  {  :host_variable  |  string_constant  }
  [  ESCAPE escape_character  ] 

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

IN Predicate

Compares a value against a set of values.

SYNTAX

expression [ NOT ] IN
  { (query_expression)
     | ( { :host_variable | constant } [ ,...  ] )
  } 

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