J (11/6/2008)
Sorry - you were wrongNo. YOU ARE wrong.
It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.
So "UNION ALL" is entirely satisfactory.
And modifying the structure of tables is hardly a "workaround". There are consequences to doing this.
Now, gimme my points! And double them for amends! Or else !
I'm a hundred percent in agreement with this reply. Plus the varchar(max) option doesn't exists in SQL 2000, which is where most SQL Server databases still are.
The answer is wrong, completely wrong!
Tom
Tom