How can I make a query like this:
SELECT id, words FROM words ORDER BY upper(words)
That I get a result like this (with the capitals intact but ordered correctly):
1. bear
2. cat
3. Dog
4. fish
5. Giraffe
Tjibbe
ps
SELECT id, words, upper(words) FROM words ORDER BY upper(words)
Works, but that's not what I'm looking for.