I am sure I am approaching this the wrong way but here goes.
I need to determine the max character length of the entire dataset from a SQL table.
The table has 40 rows and I need to be able to work out which row has the longest length of all the fields added together and what that length is.
Is there an easy way or do I have to loop through all of the fields and add them all together, then take the highest value?
THe reason why I am doing this, is that I need to set the width of a table to the exact record size. Maybe there is an easier way to do this.
Could someone please point me in the right direction, if any of this makes sense.
Many thanks
