>>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?
>
>Do not use Text fields. use n/varchar(max) instead.
What will you use in SQL 2000 to get length of the Text field?
If it's not broken, fix it until it is.
My Blog 
