Find the length of a text field

[lwrcasep]

Hello!

I am having a problem. I want to get the length of a text field. Trying to do a len(table) will give me ODBC message: Argument data type text is incalid for argument 1 of len function.

Does anyone have a way to get the length of a text field?

Thanks!

 

[sunila7]

Hi,

Have a look at DATALENGTH funtion in SQL BOL....


Sunil

 

[JamesLean]

The DATALENGTH() function will return the number of bytes used to store a value. For text type this will be equal to the number of characters. For ntext, this will be twice the number of characters.

Look it up in BOL for more details. --James

 

[lwrcasep]

Tried it and it worked. Thanks a bunch!