>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.
--sb--