James: If you want to look at the different lengths then you can: Browse series, schedule, remarks, (SLEN(remarks)) FROM allremarks This command will display the length of the remarks column; to see the largest, just sort by the "(SLEN(remarks))" column (click on the header twice and it will sort in descending order) Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of James Hageman Sent: Wednesday, February 02, 2005 10:13 AM To: RBG7-L Mailing List Subject: [RBG7-L] - finding note column size I am trying to figure out which row for a has the most characters in a certain note field. I thought i could easily do this but i am struggling. table: >list allremarks Table: allremarks No Lock(s) No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 series Type : INTEGER 2 schedule Type : INTEGER 3 remarks Type : NOTE Current number of rows: 5969 I want to know which row has the most remarks. James
