MVSFORUMS.com

[sonika2008]

I have a varchar field in table. I wanted to know the minimum and maximum size for varchar filed, the MIN and MAX function can only use for the numeric data type. Is there any function from which i can find the length for varchar , in table i have millions of records.

[jsharon1248]

Not sure what the problem is. The MIN/MAX aggregate functions can be used for any column type. For lengths, you just nest the MIN/MAX aggregate functions and the LENGTH scalar function.

[sonika2008]

Thanks for your quick response!!
Its working fine.