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.


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 3:48 PM
Subject: [firebird-support] where field = any



Hi

Is there a sql statement like this .... where FIELDA = any if I dont
want to have any criteria. THanks.

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]