...for a given value of 'fun'

I agree with Tom - questions like this serve as a good warning of those who have so little going on in their lives that they find things like the...

I didn't use Google, as I didn't know and...

One of the most bizarre questions I can remember!

I'm with those who took "which executes first" to mean "which completes its execution first" rather than "which starts its execution first".

But I suspect I'd have got it wrong even...

Hugo Kornelis (10/24/2011)Either the question's author was not aware of the simpler methods (in which case this question was a learning experience for everyone), or he was deliberately trying to...

Or if col1 isn't a bit:

UPDATE table1 SET col1 = ~cast(col1 as bit) where col1 in (0,1)

(no I know you wouldn't do it this way, but then you wouldn't do...

Or:

SELECT

CASE when Col1 is null then 'Is Null'

else case col1

WHEN '0' THEN 'Is Zero'

WHEN '1' THEN 'Is One'

WHEN '2' THEN 'Is Two'

END

end

FROM

(

SELECT...

Sean Lange (10/10/2011)[hrThis works except you can't differentiate between null and empty strings because your isnull will now treat them both the same. In some cases this is ok but...

I've a feeling the behaviour was different in a previous version of SQLServer, as I think we were bitten by it when code that worked, stopped working. I don't have...

Sneaky!

I've been bitten too many times by this sort of thing when debugging applications to be fooled though 🙂

Do you think we can keep it going until Christmas?

Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the others...

SQL Kiwi (9/20/2011)

I dream of being average, but have quite a way to go still to achieve it 🙂

I was expecting to see "undetermined, could be either" as an option so guessed (wrongly as usual).

Learned something new - not sure how useful it is to know, but these...