How to get the min and max varchar field size in DB2 table?

[LalitaForums]

Hi All,

I have a VARCHAR column in a DB2 table. I'm trying to know the minimum and maximum size this varchar filed can store. I tried using the MIN and MAX function but they can only be used for the numeric data type. Is there any function with which I can find the length for varchar, please help.

[Anuj Dhawan]

Hi,

MIN/MAX should have worked for you, try this:

Code: Select all

SELECT  MIN(LENGTH(VARCHAR_COL_A)),MAX(LENGTH(VARCHAR_COL_A)) 
  FROM  TABLE_NAME

[LalitaForums]

Great thanks Anuj.

[Anuj Dhawan]

You're welcome!