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/
