Hi

Ivan Prenosil wrote:

> > BETWEEN is inclusive, it is just that 'DA' > 'D'. Hence, in your case
> > I would use something like
> >
> > Select * from TABLE
> > Where NAME Between 'A' and 'DZZZZZZZZZZZZZZZZZZZZZZZZZZZ'
>
> ... which will not work with national characters.
>
> Better use
> NAME >= 'A' AND NAME <'D'
>

I have been following this thread. What is the difference between NAME
between 'A' and 'D' from NAME >= 'A' and NAME < 'D' I have try this in
my database it seems to give me a similar result. Which one could use
index to execute faster?

Regards,
james