WHERE Clause Syntax | VantageCloud Lake - WHERE Clause Syntax - Teradata Vantage

WHERE search_condition

Syntax Elements

search_condition

A conditional search expression, also called a conditional expression or predicate, that must be satisfied by the row or rows returned by the statement.

The arguments can be any valid SQL expression, including individual values, user-defined functions, DEFAULT functions, and subqueries, but the overall expression must be of a form that returns a single boolean (TRUE or FALSE) result.

Logical expressions include comparisons of numeric values, character strings, and partial string comparisons.

Scalar subqueries are valid search conditions.

You can specify expressions that contain LOBs in a search condition. See Expressions Containing LOBs.

Subqueries in a search condition cannot specify SELECT AND CONSUME.

You can specify a scalar UDF for search_condition only if the UDF is invoked within an expression and returns a value expression.

If you specify the value for a row-level security constraint in a search condition, you must use its encoded form.