Boolean Operators
CONTAINS
<expression> CONTAINS <value>
Description
Evaluates to True if the value returned by <expression> has <value> as a substring at any point. <expression> can be <table>.<column> or AGG(<table>.<column>, <start>, <end>).
This operator can only be applied to text columns.