Hi

No problems.

This probably should post this on the IBO list.

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: james_027
To: firebird-support@yahoogroups.com
Sent: Monday, October 18, 2004 4:08 PM
Subject: [firebird-support] Re: where field = any



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




Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]