Or use a collation instead, although "collate" is an operator it's not treated as a function:
select 'abc' n union select 'ABC' n order by n collate nocase On Tue, Dec 27, 2016 at 1:34 AM, Jean-Christophe Deschamps <[email protected] > wrote: > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
