Petite Abeille wrote:
> 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
>
Interesting, but the replacement to 'z' seems kind of a hack, I would
not prefer magic strings...
Anyway thanks for your idea!
Andres
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
