How to use SQL Order By statement to sort results case insensitive?
Solution 1:
You can also do ORDER BY TITLE COLLATE NOCASE.
Edit: If you need to specify ASC or DESC, add this after NOCASE like
ORDER BY TITLE COLLATE NOCASE ASC
or
ORDER BY TITLE COLLATE NOCASE DESC
Solution 2:
You can just convert everything to lowercase for the purposes of sorting:
SELECT * FROM NOTES ORDER BY LOWER(title);
If you want to make sure that the uppercase ones still end up ahead of the lowercase ones, just add that as a secondary sort:
SELECT * FROM NOTES ORDER BY LOWER(title), title;
Solution 3:
SELECT * FROM NOTES ORDER BY UPPER(title)