I can't figure out why these two select statements give me different results. The only difference is the where clause.

select sum(scordln.orl_qty-scordln.orl_qtyinvoiced) as nqty ;
from scordln left outer join scorder ;
on scordln.orl_order = scorder.ord_order ;
where between(scorder.ord_acct,1,201) ;
into cursor cqty

select sum(scordln.orl_qty-scordln.orl_qtyinvoiced) as nqty ;
from scordln left outer join scorder ;
on scordln.orl_order = scorder.ord_order ;
where scorder.ord_acct < 201 ;
into cursor cqty

Thanks

Pat Murphy