Were you using that function in SQL or something else though? Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 1:50 PM Subject: Re: Text Size
> 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 > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
