Re: [sqlite] Exceptions to sorting?

[Petite Abeille]

On May 16, 2008, at 10:23 PM, Andrés G. Aragoneses wrote:

> If I use "ORDER BY ItemName = '', ItemNameLowered" I get 2,1,3 and I
> want to get 1,3,2. Any ideas?

Perhaps something like:

select   *
from     item
order by case
           when name = '' then 'z'
            else name
         end

--
PA.
http://alt.textdrive.com/nanoki/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users