Indeed but, for those people that have a need to implement this functionality, it saves both band width and processing time, both on the application and the database server. If...

Glad you like it! I'd test with your new case statement but I think you'll have to change it a bit, as you need to cater for rows going down...

You are correct, my apologies. I did change the todoGroup column to be personID to make it more relevant but obviously forgot to change the table create script.

This will teach...