Hi all,
Following on Lobbie168's question. I have a similar problem but in my database I have tables such as 1234abcd, 1234efgh, 5678abcd, 5678efgh...etc.
I want to append all tables with 1234 as prefix into a single table called 1234; all tables with 5678 prefix into a single table called...