>>>Dan's syntax is what I was looking for.
>>
>>If that's the case, I posted it in the link I gave you.
>
>Maybe so, but I couldn't find the UPDATE syntax in your links. I already had the INSERT syntax, but couldn't convert it to an UPDATE.
Yes, converting that was a bit tricky. But I'm wondering why BOL doesn't show that syntax at all, but shows straight updates?
I posted a request for more documentation as I think it's absolutely not clear from BOL that this kind of syntax is needed. I can understand it's needed for regular varbinary(max) fields.
If it's not broken, fix it until it is.
My Blog