--- In firebird-support@yahoogroups.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.

Thanks.

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.


Regards,
James