SQL Server problem: Cannot resolve collation conflict for equal to operation.

Cannot resolve collation conflict for equal to operation.

The error comes when the collation type of the columns to be compared does not match or conflict.

For example if this query gives above error.

select        *
from        usertable
where        loginname = cust_no

To resolve this problem,  collate database_default  needs can be added arround "=" operator. Like below.

select        *
from        usertable
where        loginname collate database_default = cust_no collate database_default