Blogs are useful, and here’s another example why.
So how do you get the length of a field (the value) on SQLServer?
select datalength(rtrim(acolumn)) from foo;