Try this SELECT (SLEN(NoteColumnName)) FROM TableName
Good Luck, Manuel Brad Davidson wrote: >RBase 2000 DOS 6.5++ Bld 1.851xRT03 - > >Have 132 column table (WO) with 25104 rows, with NOTE field >(Work_Accomplished). When reloading database, altering table & adding >columns, get error message: > "Work_Accomplished will be truncated....". > >Am assuming this note field is causing row to exceed 255kb? Or? Is there >a way to select those rows by column WO where the note field >Work_Accomplished exceeds a predetermined value, say > 100kb? > >Any advice greatly appreciated - thanks! > >Regards, >Brad Davidson > ================================================ 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/
