Fair enough, I didn't read the original question properly. Personally i'm a fan of doing this in the code itself* rather in the query, but I doubt either of us can be arsed to do a profiling exercise to display which method is better

* Unless this is in stored proc