Razzak, Troy, Javier - Thanks so much for the tech tips - you folks have been a great help in time of need!
Troy, separating out notes to another table a good idea, as occasional fix of broken pointers on this table not possible with automatic setting in R:scope. Thanks again! Best regards, Brad "A. Razzak Memon" wrote: > At 11:35 AM 6/4/2002 -0700, Brad Davidson wrote: > > >RBase 2000 DOS 6.5++ Bld 1.851xRT03 - > > > >.. Is there a way to select those rows by column WO where the note > >field Work_Accomplished exceeds a predetermined value, say > 100kb? > > Brad, > > Option 01: > > SELECT * FROM TableName WHERE (SLEN(TextNoteColName)) > 4096 > > Option 02: > > SELECT (MAX(SLEN(TextNoteColName))) FROM TableName > > Option 03: > > SELECT (MAX(SLEN(TextNoteColName))) INTO v1 INDIC iv1 FROM TableName > > Hope that helps! > > Very Best Regards, > > Razzak. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
