# Searching for blanks/empty is there a way?

**URL:** <https://pug.phocassoftware.com/t/searching-for-blanks-empty-is-there-a-way/2304>\
**Category:** Ask the Community\
**Created:** [October 26, 2022, 7:41am UTC](https://pug.phocassoftware.com/t/searching-for-blanks-empty-is-there-a-way/2304 "2022-10-26T07:41:59Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![JonKemp](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jonkemp/32/334_2.png) [@JonKemp](https://pug.phocassoftware.com/u/JonKemp)\
**Post date:** [November 9, 2022, 9:16am UTC](https://pug.phocassoftware.com/t/searching-for-blanks-empty-is-there-a-way/2304/3 "2022-11-09T09:16:41Z")

</div>

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 🙂

---

_[View the full topic](https://pug.phocassoftware.com/t/searching-for-blanks-empty-is-there-a-way/2304)._
