Continuing problem with SQL

[Bill Mounce]

I get exactly the same results as using BETWEEN.

Bill


On Aug 22, 2006, at 7:59 AM, Sims, John (CDC/CCHP/NCBDDD) (CTR) wrote:

>
>> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina