Error by putting "Order By" clause in select quey

[rajudevare]

Hi All,
When I try to add an ORDER BY clause to a SELECT with a UNION ALL clause,
I get the following error.

Server: Msg 8626, Level 16, State 1, Line 1
Only text pointers are allowed in work tables, never text, ntext, or
image columns. The query processor produced a query plan that required
a text, ntext, or image column in a work table.

There is "varchar" field which I am using in Order by clause.

Can anyone please tell me the work around for this ?

Thanks in advance.

Regards,
Rajendra Devare

[rmiao]

Check kb article 888494, it may help.