In my test I did a query on a contact database like this:
select lastname from contacts where lastname between 'A' and 'B';
Only 'A' names are returned. Yes, there are hundreds of 'B' names. I haven't tried this with numbers and dates to see if it's the same result. I would think it should be the same. This is using 4.0.12 (I'll have to upgrade that soon). I'd be curious what your tests show.
On Tuesday, November 4, 2003, at 06:29 PM, Matt W wrote:
As a side note, Brent said that BETWEEN is not inclusive of the second parameter. But it IS inclusive.
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]