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

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 the actual output

RE: Weird Query results.

2003-07-02 Thread Jeff McKeon
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, time FROM table WHERE Name NOT LIKE zz%; I get