I have a table named folder, with a number a description, and what I need is to sort folders by the number and description.
The problem is that there are some records with no number, and these records must be at the end of the list, but with SQL, NULL is before other numbers.
I can't use UNION query, cause description is a Memo field and UNION queries don't suppor it.
So, what can I do ???
The problem is that there are some records with no number, and these records must be at the end of the list, but with SQL, NULL is before other numbers.
I can't use UNION query, cause description is a Memo field and UNION queries don't suppor it.
So, what can I do ???