Srikanth wrote:
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.
Srikanth,
Add COLLATE NOCASE to the column definition of the country column in
your table.
CREATE TABLE name (
...
country text collate nocase,
...
);
HTH
Dennis Cote