Multilevel sorts

[Ruslan Zasukhin]

On 1/21/06 1:06 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I have a three-level sort (ORDER BY) like this:
> 
> name,date,title
> 
> If the names are the same and date field is empty (NULL), the sort
> never gets to the title. If I enter data in the date field (and make
> it identical for each record), then the title sort is done.
> 
> Is this expected behavior (I don't think so -- NULL fields should
> sort identically, no)?

Interesting question.

I think it is correct behavior.

You cannot say that 10 records that have NULLs, create group of records with
the same values.

NULL - means undefined value!

        NULL != NULL


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]