query - filter "NULL" value?

[ducksunlimited]

Hi All,

What is the correct syntax of filtering NULL value out for an attribute query?  assume the field name is STATE. how to construct query.Where = ""
thanks,

Russel

[JenniferNery]

You can do something like this:
query.Where("not fieldname is null");

[ducksunlimited]

You can do something like this:
query.Where("not fieldname is null");

thank you! your codes worked.