Configure conditional expressions

You can use the following operators and wildcard characters to configure a conditional expression.

If you use wildcard characters, you can only use the operators LIKE and NOT LIKE.

Available operators

Operator	Stands for
>	Is greater than
>=	Is greater than or equals
<	Is less than
<=	Is less than or equals
=	Equals
<>	Is different than
LIKE	Is like. This operator matches a given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such. With other operators, the value is interpreted literally.
NOT LIKE	Is not like. This operator does not match the given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such.

Available wildcard characters

Use wildcards in combination with the operators LIKE or NOT LIKE only. This ensures that the wildcard is interpreted as such. With other operators, the value is interpreted literally.

Character	Stands for	Example
?	Any single character	aaa is like a?a, aba is like a?a, etc. a1a is not like a?a (1 is a digit) , adda is not like a?a (? replaces only one character).
*	Zero or more characters	aba is like aa. For example, aba, abcda, a121a, ab1da also are like aa.
#	Any single digit (0-9)	a2a is like a#a, a3a is like a#a.aza is not like a#a (z is not a digit), a23a is not like a#a (# replaces only one digit).
[<expression>]	Any character or digit	aaa is like a[abc]a, aba is like a[abc]a, etc. Other expressions: a[a-z]a, a[a-zA-Z]a, a[0-9a-z]a.

Privacy and Legal