This looks like it's sorting perfectly for me. You did misspell "Nurse" in the 3rd record, but once I fixed that, the order looks fine.

---

>Here's the minimum code to reproduce the error I am seeing. I have tried this on 2 machines, in VFP and FPW, with different COLLATE settings, and many other ways. I'm just really curious if this is out of order for other people the way it is for me.
>
>

>CREATE CURSOR Dummy (MyField C(60))
>
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nures Practitioner - PBMTU])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Program Coordinator])
>INSERT INTO Dummy (MyField) ;
>    VALUES ([CLINICAL ASSOCIATE - Dir of Women's/Children's Health])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Nurse Practitioner - PBMTU])
>INSERT INTO Dummy (MyField) ;
>    VALUES ;
>    ([CLINICAL ASSOCIATE - Physician's Associate])
>
>INDEX ON MyField TAG MyField
>BROWSE
>
>SELECT MyField FROM Dummy ORDER BY MyField
>