How To Find The Length of Data in Text and Ntext Data type :P

Hi All,

We have string function Len for finding the length of a string with VARCHAR data type.

We can’t use the LEN function for Text and Ntext data type.

For this we have another function Datalength. And we can use LEN also for this, but if u wants to use LEN u need to CAST the Text datatype column. See the below example.   

EX:   

DATALENGTH(text_column)

 LEN (CAST (text_column as varchar))

 Thanks For Visiting Blog.