Best thing about this QOTD was a good example of the CHOOSE function.

One of the Posts suggested that SQL Server 2008 R2 was the Default is interesting as I...

+1

I agree.

David

Thanks for this Question

I learned something today that I've got a use for.

David

Excellent Question. Had everybody looking in the wrong place ! Well thought out.

Thanks Hugo.

I've read the BOL entry now and it is clear about order.

Regards

David

It's a shame that "Between -1 And -10" and "Between -10 and -1" aren't equivalent in T-SQL.

I haven't read BOL re. "Between" but does it state that it has to...

I really want to learn Powershell but until I have a Problem that Powershell solves for me then it just fits into the category of a Solution waiting for a...

Straightforward Question.

Thanks

David

Some Languages use the word "Range" which is probably more descriptive than "Between". I am happy with "Between" as it's usually what I'm looking for. I can't see a use...

I'm a 3 on Tom's List.

Answer 1 was too obvious otherwise why ask the question.

Answer 1 should be the correct answer but once again SQL Server manages to conjure up...

Good Trick Question.

I don't really like SQl server when it works by Accident raher than Logic.

David

Thanks.

A good thinking and working it through question.

David

Good Question.

A few people getting carried away with Collation Sequences where it looks to me that the QOTD Author was concentrating on the last Select Statement.

I like to think of...

Good Discussion on IF...ELSE and Nulls.

I have to agree with Sean.

The IF isn't TRUE therefore execute the ELSE. This is what happened so no problem.

The Variable had no Value therefore...