fn_helpcollations (Transact-SQL)
SQL Server 2005
Returns a list of all the collations supported by Microsoft SQL Server 2005.
Transact-SQL Syntax Conventions
The following example returns all collation names starting with the letter L and that are binary sort collations.
USE AdventureWorks; SELECT Name, Description FROM fn_helpcollations() WHERE name like 'L%' AND description LIKE '% binary sort';
Here is the result set.
Name Description ------------------- ------------------------------------ Latin1_General_BIN Latin1-General, binary sort Latvian_BIN Latvian, binary sort Lithuanian_BIN Lithuanian, binary sort Lithuanian_Classic_BIN Lithuanian-Classic, binary sort (4 row(s) affected)
Reference
COLLATE (Transact-SQL)COLLATIONPROPERTY (Transact-SQL)
