How about
declare @tmpText varchar(max)
declare @textlen integer
set @tmpText = SomeTextField
set @textlen = len(@tmpText)

Glenn
>>Do not use Text fields. use n/varchar(max) instead.
>
>Well, the design is with Text field right now. So, I have to find a way to achieve that SQL.