I don't understand why so many people are so happy to be presented with a simple question, or so pleased with themselves for getting it right. personally I prefer something which makes me think.

Having said that, it depends on your collation. If you're using case sensitive collation, then statements 2,3,4 and 5 would all fail.