find the field with the largest number of characters

[impulse24]

Hi,

I have all my data stored in a SQL Database. There are four different fields, all with the field lengths set to 255, varchar fields. What is the select statment I would use to find the field that is using the largest number of characters? I would like to resize the field lengths, but there is already data existing in the table, so I want to find the data using the longest characters. Please help..Thanks

 

[rac2]

SELECT MAX(DATALENGTH(field1)) FROM anyOldTable

 

[impulse24]

worked like a charm..thanks for the help