Igor Tandetnik wrote:
> "Andrés G. Aragoneses" <[EMAIL PROTECTED]>
> wrote:
>> Andrés G. Aragoneses 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!
>> Hugh, but this seems not to be applicable for different columns,
>> because, let's suppose I have:
>>
>> ItemId ItemName ItemNameSort
>> 1 'Balloon' 'balloon'
>> 2 '' '[noname]'
>> 3 'Car' 'car'
>>
>> If I use "ORDER BY ItemName = '', ItemNameLowered" I get 2,1,3 and I
>> want to get 1,3,2. Any ideas?
>
> What's ItemNameLowered? Your table doesn't seem to have such a column.
>
> Have you tested it? I don't see how row 2 could appear first. You don't
> actually have apostrophes stored in the database as part of your data,
> do you? What does the following statement output:
>
> select ItemId, ItemName, length(ItemName)
> from myTable;
Sorry, a typo: not ItemNameLowered but ItemNameSort. When I use '' is to
differentiate it from the int type (which I used for the key). So let's
rewrite the question:
ItemId ItemName ItemNameSort
1 'Balloon' 'balloon'
2 '' '[noname]'
3 'Car' 'car'
If I use "ORDER BY ItemName = '', ItemNameSort ASC" I get 2,1,3 and I
want to get 1,3,2. Any ideas?
Thanks again,
Andres
--
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
