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;