Hi there,

I need to select each of the maxiumum length trimmed character strings from a table into variables so I can present it to a user. It will have to run on a large table so performance is an issue. Not sure wheather this can be done in a single SQL query or will need a scan through each field?

Any info much appreciated!!

Kind Regards,

Simon Swan