T-SQL automatic resizing of columns in table

[Walter Miller]

I work with very large CSV files which contain demographic information on people which is pulled into T-SQL and manipulated. The output is eventually sent to a DBASE IV file to be place into a mail sort program we use. By default the column width is set to 8000. What I would like to obtain is a procedure which automatically determine all the columns in a table (varies from database to database). Then checks for the maximum field width (SELECT max(len(<column name>)) FROM <Table Name>)and automatically trims the column to that width if greater than 8 and makes it 8 for anything less than 8 or NULL.

Example

NAME_1 TITLE
Bill Grateful CEO
Lawrence Welch
George Buches PRES
Donald Trumpy CEO

In this case there are 2 columns NAME_1 and TITLE

The longest name in column called NAME_1 is Lawrence Welch at 14 characters so I want column NAME_1 set to a width of 14.

The longest name in column called TITLE is Pres at 4 characters so I want column TITLE set to a width of 8.