How to get the largest string length of a field from a table (1 Viewer)

[darbid]

I receive about 100,000 records from another Database in Access 2003 format. I then read this data into my own database.

Given a column how can I query it to find out which record has the most number of characters in it.

Something like a MAX(LEN) function.

 

[VilaRestal]

You could do
SELECT TOP 1 * FROM Table ORDER BY Len(Field) Desc

 

[darbid]

Thank you.