>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?
>
You can select strings into the cursor and use a grid to display them. Can you clarify what filter conditions you want to applay?
--sb--