I need a way to do it in SQL. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 2:25 PM Subject: Re: Text Size
> 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 > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
