Re: [sqlite] Sorting Question

2011-04-12 Thread caurues
Thank you Igor! Now I understand. Caureus Igor Tandetnik wrote: > > caurues <caureu...@aol.com> 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

[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