--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> 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'
>
> Ivan

Thanks Guys, for the explanation & Advice
Jack