Sql Server Programming :: Counting Text Bytes


	Counting Text Bytes Isn't there an internal function to T-SQL which will actually coiunt the bytes in a text field type??? Thanks in advance. wnfisba SELECT DATALENGTH(column_name) FROM table; -- Aaron Bertrand SQL Server MVP http://www.sqlblog.com/ http://www.aspfaq.com/5006 "wnfisba" <wnfi@discussions.microsoft.com> wrote in message news:664D4D32-12F2-407A-B830-2C7EA8FF6A1B@microsoft.com... - Hide quoted text - > Isn't there an internal function to T-SQL which will actually coiunt the > bytes in a text field type??? > Thanks in advance. > wnfisba The DATALENGTH() function will probably do what you need. Unlike LEN() it includes trailing blanks, and if used with NTEXT the result will have to be divided by 2 because it counts bytes rather than characters. Roy Harvey Beacon Falls, CT On Tue, 5 Jun 2007 06:49:00 -0700, wnfisba - Hide quoted text - <wnfi@discussions.microsoft.com> wrote: >Isn't there an internal function to T-SQL which will actually coiunt the >bytes in a text field type??? >Thanks in advance. >wnfisba