get max field length [Resolved]

[ober0330]

Is there a way to get the width of the longest value in a particular field? I'm spilling all the contents of a table out onto a web page and I want to make the fields wide enough to handle the biggest value in that particular field.

DB: SQL Server 2000
Language: PHP

[Memnoch1207]

SELECT *
FROM Information_Schema.Columns
WHERE TABLE_NAME = 'TableName'

[ober0330]

That returns the maximum allowed. I'm looking for the actual max length existing in the column.

Example: Column x is a nvarchar field that can hold something 75 characters long. The longest actual entry is only 47 characters long. I want the 47 value.

[vb_dba]

Select Max(Len(x))
From TableA

[ober0330]

Perfect!