>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
>

It's probably there, the BROWSE that this query is generating is probably sing a previous length of the field. See if it scrolls and comes into view. Your field with should be 50 for myfield (the width of your PADR).