[thelist] [SQL Server] Can you do a UNION on a text column?

[Mark Mandel]

Hey guys - 

I have a bad feeling the answer is going to be 'no' - but is there a
way in which you can do a UNION on a SQL server field that is of type
'text'.

I can't convert the text field to varchar, as the text is longer than
8000 characters.

I am using SQL Server 2000 (but am happy to upgrade if that solves the issue)

Any help would be appreciated,

Regards,

Mark

-- 
E: mark.mandel at gmail.com
W: www.compoundtheory.com
ICQ: 3094740