HomeDocsAPI Reference
Kumo.ai
Docs

NOT_CONTAINS

<expression> NOT CONTAINS <value>

Description

Evaluates to True if the value returned by <expression> does not have <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.

Example

ARTICLES.DESCRIPTION NOT CONTAINS 'polyester'