SQL syntax in query filter interface

Question

Hi
I am writing some tool in ArcGIS desktop 9.3 in VBA and I need to extract data in table by query filter interface.
I have data in personal db and 
pQf.WhereClause = "TextString <> Null" 
is OK. But when I have data in File db theres a problem. I know that there is syntax a little different... but I can not find correct version.
Thanks.

RadekHýbner · Answer

correct is 
pQF.WhereClause = "YourFieldName IS NOT NULL" 
thanks

JohnHauck · Answer

You can use the following for either File or Personal geodatabase:

pQF.WhereClause = "YourFieldName IS NOT NULL"

StefanOffermann · Answer

Then you have an error in your code. The double quotes are the right way. I don't know the exact way in VBA to escape the double quotes, in C# I would write:pQf.WhereClause = "\"FieldName\" <> Null" You should check how to use <> and Null in VBA.