Wednesday, October 21, 2009

Using Transact SQL to get length of TEXT field [T-SQL]

To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won't work.

You need to use the DATALENGTH T-SQL function:
SELECT DATALENGTH(myTextField) AS lengthOfMyTextField

No comments:

Post a Comment