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