get max field length [Resolved]

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

Code:

---

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

---

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.

Code:

---

Select Max(Len(x))
From TableA

---

Perfect! :thumb: