What about this?

WHERE 1=1 OR FieldA =:ANY

Juan Jose Ochoa.

--- In firebird-support@yahoogroups.com, "james_027"
<james_027@t...> wrote:

>
> Hi,
>
>
> --- 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