>You can use DATALENGTH() on text columns but it does not ignore trailing spaces.
>
>Why stick with text if switching to varchar(MAX) will make your life much easier? From the developer point of view, the varchar(MAX) works the same as regular varchar.
As soon as I have some time, I will adjust for that.