Update single column to be case-sensitive

ALTER TABLE [table]
ALTER COLUMN [column] [type]
COLLATE SQL_Latin1_General_CP1_CS_AS [NOT NULL]

[NOT NULL] is optional