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 special symbol? What is the significance of the space bar? Is it all null values are represented as " "? But if thats the case I would have expected “Google Ltd” to have been returned.
Earth calling the uber brain 
@Tim.Leonard , are you able to validate the significance of “* *” on null fields please, are null columns stored by default with a single space? This way my head doesnt implode with the change of what the star symbol is used for 