Scripted search issue

[sandyinlet]

For the sake of a simplified user interface I'm offering users a global field to insert their search string and then applying that search among three fields. Works nicely. Finds all "Robert" entries in both first and last name fields and any records where "Robert" is included in the account name.

I've taken this further. Find all "Robert" entries which are also "active", a boolean field. This also works.

However I'm stumped on finding all "Robert" entries which are inactive, that is where the boolean field is empty. I'm unclear what the scripting strategy should be in this case.

Assistance appreciated.

[comment]

Put an equal sign in the field (as in "equals nothing").

[sandyinlet]

Excellent. Much thanks.