Depending on the purpose, you can use SELECT - SQL, or an index.

For instance, if you need this for a report, you can use:

select * from dd_cand;
  order by lname, job, salary;
  into cursor temp
report form...

For an index (temporary or permanent) to show data sorted in a grid, for instance, you simply concatenate the fields, converting different data types to character:

index on lName, job, str(salary, 12, 2) tag MyOrder

>How do I use multiple fields for sort.
>
>For example I have table dd_cand with fields lname, job, salary, etc.
>
>I want to sort 1st by lname, 2nd by job, and 3rd by salary (see
>example list below):
>
>Anderson Programmmer 20,000
>Anderson Programmer 35,000
>Bates Accountant 50,000
>Bates Notary 35,000
>Michaels Engineer 50,000
>Michaels Engineering Mgr 50,000
>...
>...
>...
>
>Thanks,
>
>F.Z. Boston, MA