Hi Cetin,

I think I encountered similar problem trying to retrieve nulls. Are both image fields nullable in both tables?

>Hi Martina,
>Thanks for replying.
>I know that works but my concern is to prevent listing of fieldnames and explicit casting.
>Cetin
>
>>Hi Cetin,
>>
>>Try this:
>>

insert into dbA..tableA select CAST(CAST(nvarchar_field AS varchar) as image) from dbB..tableA

>>
>>MartinaJ
>>
>>
>>>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