Select text length

[TysonLPrice]

I posted this once and got a response and made note of it. I can't find it.

I need to find out the lengths of a text field for a conversion. This generates an error:

select len(injurydescr) 'ctr' from claim where fkemployeraddress = 47556 order by ctr desc

Server: Msg 8116, Level 16, State 1, Line 1
Argument data type text is invalid for argument 1 of len function.

I googled and got this but it's not what I need.

SELECT DATALENGTH(injurydescr) AS TEXTFieldSize 
from claim where fkemployeraddress = 47556

How get I get the length of the date for the columns?

 

[TysonLPrice]

My bad...

SELECT DATALENGTH(injurydescr) 'ctr'
from claim where fkemployeraddress = 47556 order by ctr desc

works. I was hitting the worng database (test).