Keyword used to define string collation used for a database, column or server. Can also be used to cast the collation of a column or variable when used in a t-sql expression.
SQL Server 2000 and SQL Server 2005 allow you to use Windows Collation Names or SQL Collation Names.