>>>>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?
>
>DATALENGTH
>
>
>BTW in these very rare cases when I have Text fields in the table I don't care about its length :-)

Thanks.