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
