My deal is that I want to create my own XML response envelope with xmlized (I love this job I can make up words and folks know what I mean) cursor rows inside. So right now I have to do a CursorToXML(), StrTran twice (once to get the big fat declaration out and a second time to change "VFPData" to "Cursor(n)", and take the result text and TextMerge/concatenate it to my final result.

It would be much cleaner to just make a fragment and let me go straight to the textmerging.

I ran away from FOR XML AUTO in SQLXML once I understood what was going on; it became much easier to to FOR XML RAW and then I could format/massage the result from there.


>
>Note that without the XML declaration, it's not well-formed XML. I see what the FOR XML AUTO clause is doing in SQL Server, but still...