[4VRB] CONTINUED ERROR IN SQL (BETWEEN)

[Bill Mounce]

I continue to receive an error in the following SQL:

select * from FLASH where DIFFICULTY between 1 and 5

receives no records, even though the value for DIFFICULTY for every  
record is 5.


If I execute:

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

I likewise receive no records.


If I execute:

select * from FLASH where DIFFICULTY = 5

it finds all 1149 records. I have deleted the indexes (as per the  
suggestion from the list) and let Valentina rebuild it.


Any suggestions?

Bill