>How can we use LEN() on a Text field in SQL Server? I see this works for a Char field but what about a Text field?
Can you get rid of text fields? They are going to be deprecated. It's better to use varchar(max) instead.
If it's not broken, fix it until it is.
My Blog 
