Filter Expressions - String

Example

c.name:           ### SQL interpretation ###
- 'any'           #'any' = 'any'
- '-FOO-'         #c.name = 'FOO'
- '%FOO%'         #c.name LIKE '%FOO%'
- 'FOO%'          #c.name LIKE 'FOO%'
- '%FOO'          #c.name LIKE '%FOO'
- 'null'          #c.name IS NULL
- 'blank'         #c.name IS NULL OR LENGTH(CAST(c.name AS STRING)) = 0
- 'not -FOO-'     #NOT c.name = 'FOO'
- 'not %FOO%'     #NOT c.name LIKE '%FOO%'
- 'FOO% not'  #!  #NOT c.name LIKE 'FOO%'
- 'not %FOO'      #NOT c.name LIKE '%FOO'
- 'not null'      #NOT (c.name IS NULL)
- 'not blank'     #NOT (c.name IS NULL OR LENGTH(CAST(c.name AS STRING)) = 0)

Description

Expression	Description
any	is any value (same as no filter)
-FOO-	is equal to "FOO", exactly
%FOO%	contains "FOO"
FOO%	starts with "FOO"
%FOO	ends with "FOO"
null	has no data
blank	has zero characters or has no data
not -FOO-	matches any value except "FOO"
not %FOO%	doesn’t contain "FOO"
FOO% not	doesn't start with "FOO" (pay attention that "not" is located at the end of expression)
not %FOO	doesn’t end with "FOO"
not null	has data
not blank	has more than zero characters