RE: Weird Query results.

2003-07-02 Thread Jeff McKeon
lto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:01 AM To: [EMAIL PROTECTED] Subject: Re: Weird Query results. "Jeff McKeon" <[EMAIL PROTECTED]> wrote: > Version 3.23.56, for pc-linux on i686 > > When I issue query as such... > > SELECT ID, Name, date, ti

Re: Weird Query results.

2003-07-02 Thread Victoria Reznichenko
"Jeff McKeon" <[EMAIL PROTECTED]> wrote: > Version 3.23.56, for pc-linux on i686 > > When I issue query as such... > > SELECT ID, Name, date, time > FROM table > WHERE Name NOT LIKE "zz%"; > > I get a result that has as it's first record, a record where the Name > field data IS LIKE "zz%" but th

Weird Query results.

2003-07-02 Thread Jeff McKeon
Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE "zz%"; I get a result that has as it's first record, a record where the Name field data IS LIKE "zz%" but the actual output has that field blank as in the example below.