> 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