fn_helpcollations ()

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

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)