thelist-bounces at lists.evolt.org wrote: > 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) > I'm not exactly sure what you're asking here... I don't think of UNION as something that's done "on" a field. Do you mean something like: SELECT RowID, TextFieldA UNION SELECT RowID, TextFieldB ?