sys.fn_helpcollations (Transact-SQL)

fn_helpcollations returns the following information.

The following example returns all collation names starting with the letter L and that are binary sort collations.

SELECT Name, Description FROM fn_helpcollations()
WHERE Name like 'L%' AND Description LIKE '% binary sort';

Here is the result set.

Name                   Description

-------------------    ------------------------------------

Lao_100_BIN            Lao-100, binary sort

Latin1_General_BIN     Latin1-General, binary sort

Latin1_General_100_BIN Latin1-General-100, binary sort

Latvian_BIN            Latvian, binary sort

Latvian_100_BIN        Latvian-100, binary sort

Lithuanian_BIN         Lithuanian, binary sort

Lithuanian_100_BIN     Lithuanian-100, binary sort

(7 row(s) affected)

Reference