Continuing problem with SQL

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> I could really use some help on this. Am I the only one 
> having this problem?
> 
> The database has 1149 records.
> One record has a value of 1 in the field DIFFICULTY.
> 1148 have the value of 5 in the field DIFFICULTY.
> If I execute "select * from FLASH where DIFFICULTY between 1 
> and 5" I find 1149 records. Correct!
> If I execute "select * from FLASH where DIFFICULTY between 1 
> and 4" I find 1 record. Correct!
> If I execute "select * from FLASH where DIFFICULTY between 2 
> and 5" I find 0 records. Incorrect!
> 
> The problem looks like when all the records that should be 
> found have the same value, none of them return.
> 
> Bill Mounce
> 

Hi Bill,

Out of curiousity, what happens if you use this query instead:

"select * from FLASH where DIFFICULTY >= 1 and DIFFICULTY <= 5"

-John