>
>James,
>SQL server does that but this kind of case is not allowed in VFP SQL.
>You could do something like :
>
>

Select name, sire1, ;
>  iif(grade = "A+",1,;
>  iif(grade = "A",2,;
>  iif(grade = "B+",3,;
>  iif(grade = "B",4,;
>  iif(grade = "A",2,;
>))))) as gradeorder from master where grade # " " order by name

Cetin

Last grade= "A" ... is a leftover from pasting.
Cetin