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