Order By letters and numbers

[wayneglossop]

Hi.

I have sporting league tables which have the divisions as 'P' (Premier), '1', '2' and '3'.

I have this code installed: ORDER BY division ASC, which puts 'P' at the bottom of the list.

How can I put 'P' at the top? (then 1,2,3).

Thanks,

Wayne.

 

[guelphdad]

order by (case when division='P' then 0 else 1 end), division

that says to order by division P at the top and then all the other divisions below that. you then need division again so that the 1,2,3 divisions order within their order as well.

 

[wayneglossop]

Excellent!

Thanks guelphdad.