yes, thanx, I found it. Gotta keep the hack under 1k, right 😉 ?

thank you guys for some cool ideas, the query is way too long to post it here and i'm lazy to write a shorter example, but the select from select...

Actually, I have 4 unions there.

I was just thinking of some general solution how to order n unions by any column without displaying any 'help' columns.

Thanks,

what about without the Ordered column ?