In my humble opinion, that's presentation code and should be kept out of SQL as much as possible. :D[/quote]

I agree, but am using iReports which I know even less about...

This is great, have learnt loads. Thanks Even though am using MySQL and Oracle still very useful.

Quick one: most academic years are displayed as "06/07" any clue as...