find length of the ntext column type data in sql 2000

Question

I have a data in column which is of type NTEXT. I wanted to know the length of the data using query in sql 2000

-----Updates -----

HI, I had used the datalength thing earlier. But strangely its returning wrong values. Is there any other issue thts specific tht i shlould check.

Answer 1

You want DATALENGTH();

SELECT DATALENGTH(ntextcol) FROM T

Answer 2

You can use DATALENGTH itself.

For datatype ntext storage size in bytes, is two times the number of characters entered

This might have caused you confusion.

Answer 3

You can use DATALENGTH to get the length of a NTEXT