and
The boolean AND
operation. Conjunction of two boolean arguments using standard SQL behavior.
<condition> AND <condition>
<condition>
- A condition expression that results in a boolean value.
TRUE
- If both conditions return true.
FALSE
- If at least one of the condition returns false and no conditions return null.
NULL
- If at least one of the conditions returns null.
SQL_CONTAINS('foo') AND SQL_CONTAINS('bar')