Get max character length of column via query in MQ SQL

To gate how much character limit set on column in MS SQL

Select Character_Maximum_Length
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_CATALOG Like 'DATABASE NAME' And TABLE_NAME Like 'TABLE NAME' And COLUMN_NAME Like 'COLUMN NAME'