> 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. > 1 series Type : INTEGER > 2 schedule Type : INTEGER > 3 remarks Type : NOTE > I want to know which row has the most remarks.
SELECT * FROM Tablename + WHERE SLEN(remarks) = (SELECT MAX(SLEN(remarks)) FROM Tablename) -- Larry
