If anyone is wondering why I used the CONVERT function, the XML is stored in a column that was typed as "TEXT"...

Needless to say, it isn't "proper" XML and needed...

[font="Courier New"]Here's the solution that worked for me:

Let's recap first ... the XML is stored in an OLTP database in a table called SUBMISSION_VALUE_SET

The XML Schema is:

<java>

<object>

...

Mr Magoo,

Thanks for the reply and I appreciate the input.

It still seems that I have not phrased my question in a way that everyone gets.

The great news is that I...

Thanks Steve and I do appreciate the time it takes to set things up.

Guess I was not clear enough and my need is very basic (hence the reason I posted...

I'm not sure I understand your comment. There is sample data attached to my entry.

RTM