Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Determing size of TEXT fields....

Author  Topic 

interclubs
Yak Posting Veteran

63 Posts

Posted - 2002-07-02 : 11:16:03
I am trying to alleviate some truncating issues, and am going to try:
Response.Write(objRS("fieldname").getChunk(50000));

but was wondering if there was a way to determine the size, so that I don't have to always request the '50000' chunk.

Thanks!

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-02 : 14:13:38
look up the t-sql datalength function in Books OnLine.

<O>
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-07-02 : 15:49:31
What about TRIM() in ASP? Does that not work for TEXT fields?

Michael

<Yoda>Use the Search page you must. Find answer you will.
Go to Top of Page
   

- Advertisement -