how do i query to get the maximum characters in a field

I  need to know what is the largest number of characters in a field
I know how the field is defined. But I don't know the largest value that is used from all the records in that table

does anyone know how I can query for this info. I know it is easy to find max with number. Is ther a way somehow to do the same for characters
sikyalaSenior Database AdministratorAsked:
Who is Participating?
select max(length(your_field)) from your_table
sikyalaSenior Database AdministratorAuthor Commented:
great thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.