[sqlite] ORDER BY clause with column values not case-sensitive

[Srikanth]

Hi,
Is there a way to order the results of a select statement using the
values of a column name, with the values in that column insensitive?
E.g., If the column has the following values: Zambia, italy,Iceland,
then a regular "ORDER BY tablename.country DESC" would result in:

italy
Zambia
Iceland

I want my output to be:
Zambia
italy
Iceland.

Thanks.
Srikanth.