How to get the length of string for Text or Ntext type field

[umeshs79]

Hi,
I need the length of the string of a TEXT or NTEXT type field in my table. but as LEN() function does not work on TEXT or NTEXT type field. So please can anybody tell me how I get the length of the string in NTEXT or TEXT type field.

Thanks Umesh Sharma,MCSD
India

 

[tlbroadbent]

Use the DATALENGTH function. It will return the number of BYTES not the number of chanracters. If the column is TEXT, the number of bytes and characters will be the same. If NTEXT, the number of bytes will be twice the number of characters. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm