List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 4 2003 11:50pm
Subject:Re: query time in ~3M row table
View as plain text  
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
	dnelson@stripped
Thread
query time in ~3M row tablejabbott4 Nov
  • Re: query time in ~3M row tableBrent Baisley4 Nov
    • Re: query time in ~3M row tablejabbott5 Nov
      • Re: query time in ~3M row tableMatt W5 Nov
        • Re: query time in ~3M row tableBrent Baisley5 Nov
          • Re: query time in ~3M row tableDan Nelson5 Nov
            • Re: query time in ~3M row tableBrent Baisley5 Nov
      • Re: query time in ~3M row tableBrent Baisley5 Nov
      • Re: query time in ~3M row tableMatt W5 Nov
  • Re: query time in ~3M row tableDan Nelson5 Nov