how 'collate' function works in SQL

Question

please explain with examples

Answer 1

Refer link for reference https://msdn.microsoft.com/en-us/library/ms184391.aspx