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
