Most Characters/Digits

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Greetings again.

I need to now which word or number is the largest
(longest) in a particular field. How can this be done?
And please explain in easy English. Thanks.
 
Try this query:

SELECT TOP 1 FieldName, Len(FieldName) AS LengthOfField
FROM TableName
GROUP BY FieldName, Len(FieldName)
ORDER BY Len(FieldName) DESC;
 
Thanks, Ken, but I get this message when I run the query:

"Enter Parameter Value"

What should I enter?
 
Never mind. I found out what the problem was.
-----Original Message-----

Thanks, Ken, but I get this message when I run the query:

"Enter Parameter Value"

What should I enter?

.
Click to expand...
 
Back
Top