"Andrés G. Aragoneses" <[EMAIL PROTECTED]>
wrote:
> 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?You would have to implement a custom collation. See sqlite3_create_collation[16] Igor Tandetnik
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
