1 comes before 2 except after c.
On Tuesday, November 4, 2003, at 06:50 PM, Dan Nelson wrote:
In the last episode (Nov 04), Brent Baisley said:I had thought it was inclusive, but in quick tests I discovered it was not. I haven't tried to look it up in the documentation yet. 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.
But are there any records where lastname = "B"? "Baker" sorts below "B", for example.
-- Dan Nelson [EMAIL PROTECTED]
-- 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]