COLLATE

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.

To see a list of valid collation names, run

SELECT *
FROM ::fn_helpcollations()

See COLLATE on MSDN.

Tags: SQL Server, T-SQL