>Is there a quick command to you can run like the SUM() command that will give you the maximum length of text in a text field for all records for that field?
>Example: Record 1, field 1="this", Record 2, field1="this is cool", Reocrd 3, field 1="this is" The result I'm looking for
SELECT MAX(LEN(RTRIM(myfield))) ...
--sb--