Andre du Plessis wrote:
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__
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 g
2 matches
Mail list logo
