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

Same for me.

>

---

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