Do you know anything about Collations

I want to change the collation on a column to be case-sensitive without affecting anything else. What do I do?As far as I know the collation is set at the creation of the table. But once that is done you can explicitly change the collation type when you query the column ...

Look at the article from Kaplan on http://msdn.microsoft.com/library/default.asp?URL=/library/techart/IntlFeaturesInSQLServer2000.htm ...