Re: Retrieve XML data from SQL 2000

[Peter Flynn <peter@silmaril.ie>]

On Fri, 13 Jul 2001, Marcos A. Sanchez Rodriguez wrote:
> I need to retrieve XML data from a Microsoft SQL 2000 database with ADO 2.6.
> The tables can contains non XML valid character like "&" or "<".

If it is "XML data" as you say then it cannot contain "non XML
valid characters", so we must assume it is *not* XML data, right?

> How can I do this?

Write your extraction routines to include a filter which turns
& into &amp; and < into &lt; (in that order).

///Peter