• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

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
0
sikyala
Asked:
sikyala
1 Solution
 
sdstuberCommented:
select max(length(your_field)) from your_table
0
 
sikyalaSenior Database AdministratorAuthor Commented:
great thanks
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now