|Subject||Re: where field = any|
--- In email@example.com, "Robert martin" <rob@c...> wrote:
> I'm not sure I understand your question, if you want all the records
where the field has any value (except null) you could use
> WHERE FieldA IS NOT NULL
> and if it is a string use
> WHERE FieldA IS NOT NULL AND FieldA <> ''
> to avoid empty string results. Hope some of this helps.
Any other idea where in I will still be using the equel sign (=).
Thanks because I will be using this statement with IBO in Delphi,
wherein the parameter will have to accept a null parameter value if
the user didn't input any search criteria.