Query Language: is not null is not working

[rosalynmetz]

I have a spreadsheet that i'm querying. Below is my query:

query.setQuery('SELECT E,G where G is not null');

I'm selecting the columns E and G but I don't want it to appear when G
is null. This isn't working though. Any ideas why? There isn't a
value in some of the cells, but this query doesn't seem to work. How
can I be sure that the cell is null. The same query but using is null
gives me nothing.

What am I missing (because clearly i'm missing something).

[VizBoy]

My first guess would be that this is a column of type text and text type cells does not have a null value, only empty strings.
So please try:
where G != ""
instead

Regards,
    VizBoy.

[rosalynmetz]

Thanks VizBoy! That was it.

On Jul 1, 11:41 am, VizBoy <viz...@google.com> wrote:
> My first guess would be that this is a column of type text and text type
> cells does not have a null value, only empty strings.
> So please try:
> where G != ""
> instead
>
> Regards,
>     VizBoy.
>