SQL Server

Why it matters if COLLATE is used in WHERE