Nice trick Russell.

I was almost done with my solution to a similar problem until i saw your post. Your query is simple, easy to maintain, and it does the job.