Operand type clash: varbinary is incompatible with text

I have 3 SQL Servers (DEV, STAGE and PROD). I have a stored procedure

on DEV that will UPDATE, INSERT and DELETE rows of data from one table

on DEV to the same table on STAGE. This works fine.

I have the exact same stored procedure on STAGE that will UPDATE,

INSERT and DELETE rows of data from one table on STAGE to the same

table on PROD. This DOES NOT WORK.

All three servers have the same database and table schema. Everything

works from from DEV to STAGE. But when I try to run the stored

procedure from STAGE to PROD it fails with the following error message:

"Operand type clash: varbinary is incompatible with text"

This error above only occurs on tables that have TEXT fields. The

strange thing is it works from DEV to STAGE and they both have fields

of TEXT type as well.

Any thoughts?

http://sqlserver.itags.org/q_sql-server_214292.html