Use XML directive:

SELECT 1 as tag,
null as parent,
'<r>
<f1>My 1st content</f1>
<f2><table><tr><td>yo</td></tr></table></f2>
</r>' as [root!1!!xml]
FOR XML EXPLICIT

-Tatiana

"Maligor" <maligorwebsirius.net> wrote in message
news:OG6l3QlRDHA.2228tk2msftngp13.phx.gbl...
> Im making a select FOR XML EXPLICIT in SQL 2000 and I would like to return
a
> field that contain HTML...
>
> <root>
> <r>
> <f1>My 1st content</f1>
> <f2><table><tr><td>yo</td></tr></table></f2>
> </r>
> </root>
>
> < are replace with &lt; and > with &gt; that is actually normal...but any
> way to force a return in HTML?
>
>
>