> On Mon, 12 Apr 2004 10:58:58 -0400, SAL <2_at_2.com> wrote:>>> 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.>>> It seems to me perfectly logical. Show me everything between A and B > should not show me B itself, because I've asked for things *between* two > points, but not the points themselves.>> Of course, AZERBAIJAN would get into my list, because it's bigger than > A, and so is still between A and B.>> If you want to see Zimbabwe and Zanzibar, then your 'between' markers > need to be A at one end, and something like 'ZZ' at the other. ZZ% would > permit anything up to ZY... to be displayed.>> Regards> HJR
Sorry... I meant to prove the point.