Help.

Okay, so I'm reading through, and decided to try the case sensitive sorts:

"I’ll leave it up to you to run the SELECT statement in Listing 3 to show how the cars with a make of “Ford” will be sorted based on case."

And I refer back to Windows Collation Sorting Styles, and it indicates that "lowercase letters sort ahead of their uppercase versions." Great, so all lower case 'c's should appear before upper case 'C's. I added a couple extra entries to the same data, just so I could see it. The results were... not what I expected.

Make Model NumOfDoors ModelYear Color

-------------------------------------------------- -------------------------------------------------- ---------- --------- --------------------------------------------------

Chevrolet Volt 4 2010 Red

Chevrolet Camaro 4 1978 Green

Chevrolet Cruse 4 2012 Red

chevrolet Aveo 4 2011 White

Chevy Nova 3 1977 White

chevy Caprice 4 1984 Blue

Ford Focus 4 2012 Green

Ford Mustang 2 1964 Red

Ford Taurus 5 1995 White

ford F250 2 2010 Blue

ford F150 2 2010 Red

Honda Civic 4 2012 Red

Toyota Camry 4 2011 Red

Toyota Rav4 5 2000 Red

So, I expected all the lower case 'c's to be sorted together (as if lower case 'c' were a different letter, that came slightly before capital 'C' in the alphabet... it would appear that Upper Case letters sort first. (And why wouldn't these sort as 'chevrolet', 'chevy', 'Chevrolet', 'Chevy'?) The query run is Listing 3... with slight changes in the data.

Is the documentation wrong, or have I participated in too many Father's Day activities in the bright Maryland sun? (I assume it doesn't make any difference, but I'm using SQL 2008 R2 Dev Ed. (10.50.2500)