subject:"\[sqlite\] Sorting Question"

Re: [sqlite] Sorting Question

2011-04-12 Thread caurues

Thank you Igor! Now I understand. Caureus Igor Tandetnik wrote: > > caurues wrote: >> I am hoping I can get an answer to my question. I want to sort a column >> in >> ascending order, but I want null values to sort to the bottom. A simple >> ORDER BY ColumnA ASC sorts

Re: [sqlite] Sorting Question

2011-04-12 Thread Igor Tandetnik

caurues wrote: > I am hoping I can get an answer to my question. I want to sort a column in > ascending order, but I want null values to sort to the bottom. A simple > ORDER BY ColumnA ASC sorts the column in ascending order with null vales > appearing on top. The following

[sqlite] Sorting Question

2011-04-12 Thread caurues

I am hoping I can get an answer to my question. I want to sort a column in ascending order, but I want null values to sort to the bottom. A simple ORDER BY ColumnA ASC sorts the column in ascending order with null vales appearing on top. The following code, however, works correctly, but I have no