>>>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.