Testing for Both Zero and Blanks within a Select Statement

[bhujanga]

What is the syntax for testing for blank cells within a select statement. It seems to consider them identical to 0, and this will not always be the case. If the cell contains zero it is valid data and must be viewed differently than is there is nothing there.
If I use Case Null:
it skips right over it.
Thanks.

 

[SkipVought]

Hi,

Length()=0?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[mintjulep]

IsBlank()