ASA SQL Reference
  SQL Language Elements
    Search conditions

EXISTS conditions

The syntax for EXISTS conditions is as follows:

EXISTS( subquery )

The EXISTS condition is TRUE if the subquery result contains at least one row, and FALSE if the subquery result does not contain any rows. The EXISTS condition cannot be UNKNOWN.

Standards and compatibility 

• The EXISTS condition is compatible between Adaptive Server Enterprise and Adaptive Server Anywhere.