can wild cards be used in BETWEEN clause

Hi,
I am trying to select names of all countries from a column: SELECT country FROM countries_table
WHERE
country BETWEEN 'A%' AND 'Z%';

This gives me every name except those starting with Z. I wonder if this is the right approach.
Any help will be appreciated.

Thanks. Received on Mon Apr 12 2004 - 09:58:58 CDT