Bob, SELECT Col_Name, (SLEN(Col_Name)) FROM Table ORDER BY 2 desc, 1
will show you what you want - and you can see how many rows there are at the upper limit so that you can decide if you want/need to truncate some one way or another. Personally, I'd hive the note field an an idnumber off to a new table and keep it as a note column. Regards, Alastair. (NB: you seem to need both sort columns now!) ----- Original Message ----- From: "Bob Castanaro" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 03, 2003 9:41 PM Subject: [RBASE-L] - RE: Table Design > I too have had some problems with broken pointers in the past on note > fields. I'm now going to convet a large (300mb) database. I have one > table where critical data is in a NOTE field and I want to convert this to > a text field. How do I count the maximum number of chars in the note > fields so i can set a max of the new text field? > TIA > Bob C. > > > > > "Fogelson, Steve" <[EMAIL PROTECTED]> on 09/02/2003 > 08:09:40 PM > > Please respond to [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] (RBASE-L Mailing List) > cc: (bcc: Bob Castanaro/BCH) > Subject: [RBASE-L] - RE: Table Design > > > > > Thanks for all the great information. > > Steve Fogelson > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 02, 2003 5:43 PM > To: [EMAIL PROTECTED] > Subject: [RBASE-L] - RE: Table Design > > > I dislike NOTE fields in main tables. When a database is in severe trouble, > R:Scope cannot find next rows to fix the pointers when the row has a > variable length. > > With note fields in a table, the likelihood of having problems increases, > simply because of the need to move the row to the bottom of the table when > the note exceeds the original plus the padding. > > > > "Fogelson, Steve" <[EMAIL PROTECTED]> wrote: > > >I am new to this list. > > > >If I have 8 text fields that I want a table to have, would it be better to > >use 8 Note fields vs. 8 Text fields of 80 characters? > > > >Would the Note fields use less disk space that the allocated Text fields > of > >80 characters? > > > >I know this would allow me to use more than 80 characters in some of the > >fields, so that would be a benefit. > > > >Are there any draw backs to a Note field? > > > >Also, will I lose any data in a Text field that I convert to a Note Field? > > > >Thanks > > > >Steve Fogelson > >Internet Commerce Solutions > > > > > > > -- > Albert Berry > Full Time Consultant to > PSD Solutions > 350 West Hubbard, Suite 210 > Chicago, IL 60610 > 312-828-9253 Ext. 32 > > > __________________________________________________________________ > McAfee VirusScan Online from the Netscape Network. > Comprehensive protection for your entire computer. Get your free trial > today! > http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 > > Get AOL Instant Messenger 5.1 free of charge. Download Now! > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 >
