collation error occures in sql2k5

If a collation error occurres then can be resolved by mentioning the collation in query such like that

SELECT Column1, Column2


FROM MyTable M

WHERE EXISTS (SELECT * FROM ThisTable T WHERE M.Column1 = T.Column1

COLLATE Latin1_General_CI_AS)