All,
Many thanks for your thoughts on the merging of columns. The tr method would have killed all the delimiters as a few
peoplenoted. The || method in SQL was the winner, although the final table this has to be done to (4 million records)
shouldkill the system for a while!!!!! Must make sure I've got enough disk space to do it all as well. Maybe doing it a
sectionat a time would be in order.
Thanks to all,
Gary MacMinn