Subject | case sensitive "order by" |
---|---|
Author | Anton Malinovskiy |
Post date | 2005-04-11T09:07:15Z |
Hello everybody,
I've found that select statements like:
select id, name
from Human
order by name;
are case sensitive and the only way for case insensitive "order by" which
I've found is select statement like:
select id, name, upper(name)
from Human
order by 3;
But this solution doesn't suit me. Is the any other solution?
Thank you in advance.
[Non-text portions of this message have been removed]
I've found that select statements like:
select id, name
from Human
order by name;
are case sensitive and the only way for case insensitive "order by" which
I've found is select statement like:
select id, name, upper(name)
from Human
order by 3;
But this solution doesn't suit me. Is the any other solution?
Thank you in advance.
[Non-text portions of this message have been removed]