Conditional ODER BY Clause HELP

[Don Wieland]

Hi gang,

Trying to get the correct syntax on this:

ORDER BY 
CASE 
        WHEN tr.Placed = "X" THEN r.Division ASC, 
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), 
tr.Score DESC 
        WHEN tr.Placed != "X" THEN tr.ride_time ASC 
END


How does one deal with CONDITION study like this?

Thanks in advance for any assistance

Don