Igor Tandetnik wrote:
> "Andrés G. Aragoneses" <[EMAIL PROTECTED]>
> wrote:
>> Hello, I am querying a list of elements and some of them are blank
>> (''). However, I want that those who are blank appear as the last
>> (instead of the first) elements when I sort with ORDER BY
>> alphabetically. How can I do this with just SQL?
>
> ORDER BY text = '', text
It works thanks! I've also noticed that every non-alphabetical character
is also ordered before alphabetical ones, how can I invert this behaviour?
Regards,
Andres
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
