ecoleman

I did actually flip it around in the end

Superb, I ended up with SELECT name from table ORDER BY CASE WHEN primary_order != '0' THEN primary_order ELSE secondary_order END and that works a treat. Thank You.

Hi, I need to sort a query by two columns, but only use the second column value if the first column is equal to 0. eg. Name | Primary Order | Secondary Order Fred | 1 | 10 Sue | 0 | 2 William | 10 | 3 Richard | 0 | 1 would ideally be sorted as (Primary Order or Secondary (If Score = 0)), name which should produce a result like Fred - (1) Richard - (1) Sue - (2) William - (10) Any help would be greatly appreciated. Thanks in advance.