Re: What does like '%%' mean

2001-11-29 Thread Douglas L. Brown
It is keying on the fact that you left a field blank on the request. If you have that in there it will pull all records with your search criteria and disregard the fact that a field is empty. Doug - Original Message - From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL P

RE: What does like '%%' mean

2001-11-29 Thread Richard Colman
reciated? -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:12 PM To: CF-Talk Subject: Re: What does like '%%' mean It is keying on the fact that you left a field blank on the request. If you have that in there it will pu

RE: What does like '%%' mean

2001-11-29 Thread Jared Clinton
Null values may not be treated the same as empty strings. Jared Clinton. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 November 2001 3:12 PM To: CF-Talk Subject: RE: What does like '%%' mean It is not actually working that way, and I can

Re: What does like '%%' mean

2001-11-29 Thread Don Vawter
My guess is that you have nulls which won't satisfiy any condition - Original Message - From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 10:11 PM Subject: RE: What does like '%%