[sqlite] Wierd between results

[Lloyd Thomas]

I am not sure if I am being crazy, but I seem to be getting a wierd result 
when using 'BETWEEN'.

if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
but if I do
SELECT count(call_id) as num_rows WHERE ring_time = 7;
I get 39 results
SELECT count(call_id) as num_rows WHERE ring_time > 6 and ring_time <10;
Also gives 0 results.

Where am I going wrong?

sqlite 3.2.8
windows XP

Lloydie-T