Different collations on databases 1

[vbtest5]

Hi,

I have two databases and want to write an SQL to retrieve data from two tables. Both the tables are in different databases. Database 1 has collation set to SQL_Latin whereas database 2 has collation set to Windows Collation: Latin1_General. Because of this, my SQL gives me collation error. Is there any solution for this?

Regards,
Varsha

 

[ClayG]

You can explicitly convert collection in an expression where you use a column, eg,

where m.fullname =
a.fullname collate sql_latin1_general_cp1_ci_as