>Can anyone explain why this does not put the record with "PBMTU" (Pediatric Bone Marrow Transplant Unit) in the last position?
>
>It's for an internal report and really doesn't matter, except that I'm really surprised it comes out in this order.
>
>

>CREATE CURSOR Dummy (Rec N(1), MyField C(60))
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (1, "CLINICAL ASSOCIATE - Nurse Practitioner")
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (2, "CLINICAL ASSOCIATE - Nurse Practitioner")
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (3, "CLINICAL ASSOCIATE - Nurse Practitioner")
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (4, "CLINICAL ASSOCIATE - Nurse Practitioner")
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (5, "CLINICAL ASSOCIATE - Nurse Practitioner")
>INSERT INTO Dummy (Rec, MyField) VALUES ;
>    (6, "CLINICAL ASSOCIATE - Nurse Practitioner")
>
>SELECT Rec, ;
>    PADR(ALLT(MyField) + IIF(Rec = 3, " - PBMTU", ""), 50) ;
>    AS MyField ;
>    FROM Dummy ;
>    ORDER BY 1, 2
>

Perhaps because you sort on Rec first and MyField only after Rec. Since you never have two distinct records with Rec = 3, the second sort condition is irrelevant.