Progress
SQL-92
Guide and Reference


Search Conditions

A search condition specifies a condition that is true or false about a given row or group of rows. Query expressions and UPDATE statements can specify a search condition. The search condition restricts the number of rows in the result table for the query expression or UPDATE statement.

Search conditions contain one or more predicates. Predicates that can be part of a search condition are described in the following subsections.

This is the syntax for a search_condition:

SYNTAX
[ NOT ] predicate 
  [ { AND | OR } { predicate | ( search_condition ) } ] 

predicate:

SYNTAX
basic_predicate
  |   quantified_predicate
  |   between_predicate
  |   null_predicate
  |   like_predicate
  |   exists_predicate
  |   in_predicate
  |   outer_join_predicate 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095