KATER__TEXT_DOES_NOT_CONTAIN

Family: Conditions

Syntax

1
KATER__TEXT_DOES_NOT_CONTAIN(field, value)

Arguments

Returns

TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.

Usage notes

• A row whose field is empty is left out too, since the comparison with an empty value is not true.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.notes AS "Notes",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__TEXT_DOES_NOT_CONTAIN(orders.notes, 'gift')
7
GROUP BY
8
  orders.notes
9
ORDER BY
10
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
NOT CONTAINS(LOWER(orders.notes), LOWER('gift'))

See also

• Filters and parameters
• Other functions in Conditions: KATER__IS_EQUAL_TO, KATER__IS_NOT_EQUAL_TO, KATER__IS_GREATER_THAN, KATER__IS_AT_LEAST, KATER__IS_LESS_THAN, KATER__IS_AT_MOST, KATER__IS_BETWEEN, KATER__IS_ONE_OF, KATER__IS_NOT_ONE_OF, KATER__TEXT_CONTAINS, KATER__IS_NULL, KATER__IS_NOT_NULL