Hello mate,

This will do the trick - simply inserting the DIR result set in to a table and then reading that table.

Its a temp table, so please try...

Hello,

I think the case statement is fair enough as the definitions of field size are something that is not gleaned from the tables in terms of INT etc.

The...