I usually do something like this: SELECT series, schedule, (SLEN(remarks)) + FROM allremarks ORDER BY 3 DESC
--- James Hageman <[EMAIL PROTECTED]> wrote: > 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 > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
