Try using the substr, since you are only comparing the first letters...
(sorry I did not reply all on the other email, Dan)
i.e.
select name from users where substr(name, 1, 1) >= 'A' and substr(name,
1, 1) <= 'B';
-B
Dan Shirah wrote:
So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll
get you
Aa-Fz :)
On 5/18/07, Tony Grimes <contact@xxxxxxxxxxxxxx> wrote:
We tried that and it didn't work. We've also tried every combination of
upper and lower case too.
Tony
On 5/18/07 2:18 PM, "Brad Bonkoski" <bbonkoski@xxxxxxxxxxxxxx> 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')
> -B
>
>
> Tony Grimes wrote:
>> I'm using BETWEEN to return a list all people who's last names fall
between
>> A and F:
>>
>> .... WHERE last_name BETWEEN 'A' AND 'F' ...
>>
>> but it's only returning names between A and E. The same thing happens
when I
>> use:
>>
>> .... WHERE last_name >= 'A' AND last_name <= 'F' ...
>>
>> Shouldn't this work the way I expect it? What am I doing wrong?
>>
>> Tony
>>
>>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
