Sorry if this is actually a noob question, how do I do an ansi style order by in sqlite
For example A b a B Would be sorted as A B a b but what you want is a A b B I can do order by upper(column) But then things like __new__ Goes to the bottom and should go to the top Thanks.
