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