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