retrieve column length

[Garth]

Is there a quick way of running an SQL query that will provide the maximum length of data that can go in a particular column? I created a table, and want to be able to limit text input so that the maximum field length is not exceeded

[Mauricio Ritter]

if you´re using ADO, you can use the DefinedSize propertie. Mauricio Ritter - Brazil Sonorking now: 100.13560 Trank

[notadood]

If you are using SQL Server then: SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'yourtablename' AND COLUMN_NAME = 'your column name'