At 00:45 27/12/2016, you wrote:
The work arounds is using a WITH clause or putting the upper function expression in the output of each select.
Another way to rewrite is to wrap the compound select inside a simple outer select:
select n
from
(
select 'Abc' n
union
select 'aaa' n
)
order by upper(n)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
