Thanks! You are without doubt a genius.

I had a slight problem because some tables use NTEXT or had spaces in the table name but your solution has saved me hours.

Thanks...

Hi again Seth

I don't know if this ackground helps. For every string fieldname in tablename I am checking to see how large the entries are. This is what...

Hi Seth, thanks for responding.

The essence of the problem in NOT being specific. It needs to run for every column.