ahhhh...no I use it on the CF side 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 12:17 PM Subject: Re: Text Size > 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 > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
