The combination of columns updated and not updated
happen to create a bit sequence that get interrepted as
space(s). The len function ignores trailing spaces
and sometimes that leads to ignoring everything
(particularly when you only have one byte and that bytes is a space);
thus, the result is zero -- as designed.
Instead of using LEN, read about DATALENGTH in BOL.
"Mario" <org> wrote in message