Asked and answered in .datamining. Please do not multipost.
Signature
Adam Machanic Pro SQL Server 2005, available now http://www.apress.com/book/bookDisplay.html?bID=457 --
> In TSQL how to use OPENXML to open an ntext field in a table? I can not > read > the ntext into a local var as TSQL does not allowe ntext local variables.