The error occurs with code like:

insert into dbA..tableA select * from dbB..tableA

The structures are same and one of the fields is an image field (photo). It happens when photo has null (I understand that then it uses the default datatype varchar). Is there a solution to this other than listing all of the fields and casting?

Note that this is an SQL server question, I posted on VFP forum thinking it has a wider audience.
TIA

Cetin