"Lloyd Thomas" <[EMAIL PROTECTED]> wrote: > 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. >
Please send me your database by private email and I will take a look. -- D. Richard Hipp <[EMAIL PROTECTED]>