ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-28
Search Conditions
Search Conditions
Use Transact-SQL syntax in search conditions when using the NonStop ODBC Server.
All supported search conditions work the same as in Transact-SQL.
The syntax of a search condition is any of the following:
For more information on search conditions, see the Microsoft SQL Server Transact-
SQL Reference.
WHERE expression comparison-operator expression
WHERE [ NOT ] column-name [ NOT ] LIKE "match-string"
WHERE [ NOT ] column-name IS [ NOT ] NULL
WHERE expression [ NOT ] BETWEEN expression AND expression
WHERE expression [ NOT ] IN ( { value-list } )
{ subquery }
WHERE [ NOT ] EXISTS ( subquery )
WHERE expression comparison-operator { ANY } ( subquery )
{ ALL }
WHERE [ NOT ] column-name join-operator column-name
WHERE boolean-expression
WHERE expression { AND } expression
{ OR }