Wow, ouch. That is an awfully bright light bulb that just lit up in my head. Duh, too obvious for me to see.

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]



Reply via email to