On Apr 16, 8:15 pm, Mark McDougall <msmcd...@no.spam.iinet> wrote: > Jonno Downes wrote: > > SELECT criteria_description FROM VenueSelectionCriteria ORDER BY > > CASE > > WHEN criteria_description="table space" THEN 1 > > WHEN criteria_description="good audio visuals" THEN 2 > > WHEN criteria_description="comfy seating" THEN 3 > > END ASC > > I give up - SQL???? indeed.