• Interesting approach.

    But all three examples cause a clustered index scan. I wonder if the author thought about that. I would not use such queries on a large table.