"Paul" wrote:

>
> Hi,
> I need to query XML data that is held in a text field on a SQL Server 2000
> table, the XML includes DTD and Data elements.
> For example the XML has a data element named S1 and I want to list all the
> records where S1 is like ‘%house%’. I would also like to be able to list all
> the fields from the XML in a grid but the names and quantities of the
> elements are not known they are basically a user defined form data stored as
> XML in a field.
> The database is part of a purchased software package, I don’t like the way
> the data is stored but unfortunately I have to work with it so any ideas
> would be welcome.
>
> Thanks,
> Paul.
>