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