Hi guys, just a quick update on the Group by order by question.

It´s working like a charm, but now, there is a new requirement.

This is my code : select ...

It was mostly to do with U/I presentational stuff, showing how many had graduated from the school it´s first and last years.

I solved it with some VB programming so it´s...

That worked cheers mate...

one more question, say I wanna take first and last year and skip all the ones in the middle?

Yes of course, sorry if I was unclear.

Column name is Year, datatype is varchar and it looks like a 4 digit year ie 1800, but again I must stress it...