Advanced Filtering 'Is Blank' Option

[JonKemp]

HI @scottmunroe ,

This came up by me as well a while ago please have a read of this post:

Searching for blanks/empty is there a way?

Hi @tim.janes , Thanks, very grateful for the tip! This works…but the SQL developer in me makes me feel uncomfortable. For example using “* " , in SQL land it should mean look for anything before the space and after the space, so “Google Ltd” has a space in it so I would expect that to be returned but it does not. In proper ISO SQL standards it would be “%” instead of "”, however depending on platform these symbols can be interchangable. So in the case of Phocas does this mean the “*” is a …

It would be nice for what you requested but it is possible.

Regards,

Jon