Welcome to Julian Kuiters Monday, May 21 2018 @ 07:41 AM AEST

COLLATE

  • Contributed by:
Glossary
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.