One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not reading the question carefully. So, how could this question have been written better?
(The only thing that I can think of is to have bolded the "as a true / 1 value".)
I see nothing wrong with this question. As long as you take the time to read the entire question, I fail to see how one could misunderstand it.
Maybe people who misread the question were only flying over the text and making assumptions on what the question is?
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis