Web lists-archives.com

Conditional ODER BY Clause HELP




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