Typically a database is set to Case Insensitive collation. This approach has many advantages, because case sensitivity adds another layer of complexity to the database application. However, sometimes the applications require Case Sensitive columns. If it is a third party application, it may require that the entire database be set Case Sensitive. In-house applications, however, can be satisfied by setting specific columns as Case Sensitive.

Execute the following script in Query Editor to set a column to an Case Sensitive collation. Rebuild the table after the change:

ALTER TABLE SalesDiscount ALTER COLUMN DiscountType varchar(40)
COLLATE SQL_Latin1_General_CP1_CS_AI null

Alternate approach - use a case sensitive collation in ORDER BY:

SELECT ProductName=Name, ListPrice

FROM AdventureWorks2008.Production.Product

WHERE ListPrice > 0

ORDER BY Name COLLATE SQL_Latin1_General_CP850_CS_AS

/*

ProductName             ListPrice

All-Purpose Bike Stand  159.00

AWC Logo Cap            8.99

Bike Wash - Dissolver   7.95

Cable Lock              25.00

Chain                   20.24

.....

*/