jeudi 22 octobre 2015

Android Sqlite Order by number then letter then emptyString or null

So I have a query that return number, letter and empty string with

 order by lower table.thecolumn

and return me as this order which is right

-empty string

-number

-letter

but I want them to order by

-number

-letter

-empty

Is there anyways I can achieve this with sqlite query or through codes.

Aucun commentaire:

Enregistrer un commentaire