>No problem. It's an interesting exercise but I've a feeling I'd be loading too much logic onto the SQL server anyway...

Hi Viv,

I took a closer look at the data and I don't think it's possible to do that with a query. I may be mistaken, though.