Subject Re: usage of = and between in queries
Author Adam
--- In, Vahan Yoghoudjian
<vahan@p...> wrote:
> Thanks for the quick reply Adam
> What about
> where (CODE between 'AAAA' and 'BBBB')
> and
> where (CODE >= 'AAAA' and CODE <= 'BBBB')
> Hint: All those conditions I use are on varchar fields and non of
them on
> numerical fields.

It wouldn't matter even if they were numeric fields. They are
internally equivalent statements. Check the query plan (pretty much
any tool tells you) and you will notice it uses the same index if