OK, Jean Marc checked and they are. Only whichever is the first one in the WHERE clause gets evaluated, never both at the same time.
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 04, 2008 12:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PopUp Dynamic Where Clause Don't quote me on this, but I think I tried this once and both of the fields have to be displayed in your popup. Are both yours? Karen Follow-up question on this subject. WHERE field1 CONTAINS '&' works fine, but WHERE field1 CONTAINS '&' OR field2 CONTAINS '&' WHERE (field1 CONTAINS '&' OR field2 CONTAINS '&') Only brings up the results of the field1 comparison. Anything else I'm missing? TIA, Claudine
