Query:

select * from fn_helpcollations()
where name like ‘%SQL_Latin1_General_CP1_CI_AS%’
or name = ‘Latin1_General_CI_AS’
or name like ‘%cp1%’

Query result:

read more »