Claudine Not sure why it isn't documented. If you want to use LIKE instead of CONTAINS change your where clause to this
WHERE company_name LIKE '&%' If the setting for many is percent (%) Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Saturday, August 02, 2008 8:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DBEdit Properties PopUp Dynamic Where Clause Thanks Buddy, that's exactly what I needed. I wonder why this is not documented anywhere. Claudine -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Saturday, August 02, 2008 7:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DBEdit Properties PopUp Dynamic Where Clause Claudine Make sure you check the box for "Use Dynamic Where Clause" In the message box type in "Enter a Partial Name' in the where box type in WHERE company_name CONTAINS '&' Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Saturday, August 02, 2008 8:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - DBEdit Properties PopUp Dynamic Where Clause Does anyone know the correct syntax for the "Use Dynamic Where Clause" in a form DBEdit popup? WHERE company_name CONTAINS @'Enter a Partial Name' Doesn't test properly and therefore doesn't work. TIA, Claudine
