[V4RB] SQL error

[Bill Mounce]

I have a database with a column (named TYPE) where all the records  
have the value 5. I issue the following SQL:

select * from XXXXX where TYPE between 1 and 5

No records are returned. Then I tried:

select * from XXXXX where TYPE between 1 and 6

It found all the records (even though the manual says "between 1 and  
5" is the same as TYPE >= 1 and TYPE <=5)

I did the same exercises within code (SQLSELECT) and Studio.

Any suggestions?
Thanks.

BIll