I remember I had the same problem for the between dates. for example, Select * FROM the_table WHERE the_date BETWEEN '2007-01-01' AND '2007-01-31', the problem that it wasn't including the 2007-01-31, I discovered later on that it should be something like: SELECT * FROM the_table WHERE the_date BETWEEN '2007-01-01' AND '2007-01-31 23:59:59' -- itoctopus - http://www.itoctopus.com "Tony Grimes" <contact@xxxxxxxxxxxxxx> wrote in message news:C2737215.330FE%contact@xxxxxxxxxxxxxxxxx Yeah, but what do I do for Q-Z? I guess I¹ll have to write a condition to use last_name >= OQ¹ if it finds a Z. I¹ll have to write conditions to look for other exceptions too. Aaarrgh! *looks up at the Gods* Damn you BETWEEN! Why must you torture me so!?! Have a good weekend. On 5/18/07 2:51 PM, "Dan Shirah" <mrsquash2@xxxxxxxxx> 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 >> <http://www.php.net/unsub.php> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
