[dba-SQLServer] JOIN Issue with Databases

Hi,

I've got 2 business applications that use SQL Server 2000 databases, one is:
 COLLATE SQL_Latin1_General_CP850_BIN
the other is:
 COLLATE SQL_Latin1_General_CP1_CI_AS

Trying to join data from tables in each database on a PO field (Varchar(10)) results in the error:
Cannot resolve collation conflict for equal to operation.

Does anyone know a workaround for this?  The databases are required to be Collated as is and I've tried modifying the join fields via Cast 
INNER JOIN ({field} AS VarChar(10)) =  ({field} AS VarChar(10)) 

But this results in the same error.

Thanks,
Chris Mackin