Geezzz... that was quick... thanks a lot, I should get out of the box and look from the outside more often, he he...

Rajesh,

Thanks for your answer, I tried that but the text files came in a really bad format, even thought I exported them as tab delimmited, comma delimited and any other...

Frank,

It work great, thanks a lot.

Unfortunatelly I have to use that data as it is not my design, is data that comes from someone else, poor design, I know but...

Frank,

Thanks for your input, I tried but it did not work because the tables have different columns so I can not use the Union All.

Here is some data per your request:

Table1:

number     features 

---------- ---------------------------------------------

111670.0   1|2|3|4|5|6|7|67|74|76|80|84|88|92|106

113650.0   1|13|21|29|30|31|42|43|45|49|55|67|74|84|87

115354.0   12|15|23|31|34|39|49|54|67|71|76|84|88|92|106

116772.0   11|31|34|41|43|44|49|52|53|71|76|92|96|97|98

117756.0   3|15|21|31|34|49|63|73|77|84|88|92|100|102

118294.0   29|74|76|83|87|92|106|128|133|138

Table2:

FeatureCode FeatureDesc 

----------- -------------

1               Attached

2               Carport

3               Detached

4               Direct Entry

5               Heated

6              ...