So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll get you
On 5/18/07, Tony Grimes <[EMAIL PROTECTED]> wrote:
We tried that and it didn't work. We've also tried every combination of
upper and lower case too.
On 5/18/07 2:18 PM, "Brad Bonkoski" <[EMAIL PROTECTED]> wrote:
> I think you need between 'A' and 'F%'
> Aa is between A and F
> but 'Fa' is not between 'A' and 'F'
> (but 'Ez' would be between 'A' and 'F')
> Tony Grimes wrote:
>> I'm using BETWEEN to return a list all people who's last names fall
>> A and F:
>> .... WHERE last_name BETWEEN 'A' AND 'F' ...
>> but it's only returning names between A and E. The same thing happens
>> .... WHERE last_name >= 'A' AND last_name <= 'F' ...
>> Shouldn't this work the way I expect it? What am I doing wrong?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php