>>>Hi everybody,
>>>
>>>I'm getting this error "Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query."
>>>
>>>I pass NULL as my parameter for varbinary(max). In the stored procedure code I use ISNULL(@DefaultPicture, CONVERT(varbinary(max),''))
>>>
>>>What should I do to fix the problem?
>>>
>>>Thanks in advance.
>>
>>

>>   ISNULL(@DefaultPicture, CONVERT(varbinary(max),0x0))
>>

>>
>>or even:
>>

>>   ISNULL(@DefaultPicture, 0)
>>

>
>The first approach also created 4 bytes array. I will switch back to ''

What array in TSQL?