Expression Syntax

Like

“Like” can be used to create an expression to look to see if a string to exists anywhere in a column. For example, if you want to filter to include only names which have the string “ing”:

name like “%ing%”

IN

mpu_id in (1025706, 1331984)

NOT (Watch out!)

Compound expressions which contain NOT can give you unexpected results. Be liberal with parentheses to make ambiguities clear. For example:

NOT IsNull(bk_ver_slc_id) and bk_ver_id = 9999

Gives different results than

(NOT IsNull(bk_ver_slc_id)) and bk_ver_id = 9999