I've been seeing errors like this recently in my work:
Cannot resolve collation conflict for equal to operation.
I've fixed my problems by designing queries in Design View of views then examining the resulting SQL and things like the following have been appearing.
I haven't got a clue what this all means though but it's obviously pretty important. Can anyone explain what this is all about?