Sql – Order a select result case insensitively

databasedb2selectsql

Is it possible to order the result of select query on a db2 database case insensitively?

For example:
I want to have all names that start with an "a" or "A" sorted together.

Abraham
aron
andrea
Annica
brian
Benjamin

Now it's like this:

aron
andrea
brian
Abraham
Annica
Benjamin

Best Solution

order by lower(columnname);