Logical predicates are typically used in a WHERE, ON, or HAVING clause to qualify or disqualify rows as a table expression is evaluated in a SELECT statement.
Logical predicates can be used in a WHEN clause search condition in a searched CASE expression.
The type of test performed is a function of the predicate.