Are you sure Len() doesn't work on the "text" datatype? I'm pretty sure I use it to only show the first "x" characters of text fields followed by "...click for more".
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ----- Original Message ----- From: "Bernd VanSkiver" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 11:40 AM Subject: Text Size > I am using Microsoft SQL 2000. Is there a way to see how many > bytes/characters a specific field is taking up that is datatype text? I use > the LEN() function on varchar and char datatypes to get then length, but > that function doesn't work on text datatype fields. > > Bernd VanSkiver > [EMAIL PROTECTED] > ColdFusion Developer > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
