Should have also said I think some of the databases support the substr function. Might be called something different like substring. Maybe this will help. ... View more

Not sure if this helps but..   to get the length of all of the columns I use the datasaets procedure and load the metadata, ie length of columns into a macro array.  Then I use the macro array to build the SQL. ... View more