declare @DefaultPicture nvarchar(max) set @DefaultPicture = null create table #test (Def varbinary(max) null) set @DefaultPicture = convert(varbinary(max),@DefaultPicture) insert into #test values (ISNULL(@DefaultPicture,0))So, it goes back to my question nobody helped me with - how can I create null byte array. I tried BitConverter.GetBytes[0], but it created 4 bytes array. I want to be able to return null array.
> ISNULL(@DefaultPicture, CONVERT(varbinary(max),0x0)) >>
> ISNULL(@DefaultPicture, 0)
>