Thanks for your suggestions and sorry about delay of reply - have been out of office for a couple of days/

Unfortunately, as good as they are, the suggestions do not...

Jonathan,

Thank you. I have tested the code you have provided and is somewhat similar to what I came up with... but it falls into the same problems... I'll keep working...

Everyone,

Thanks for all suggestions and possible solutions. I should be able to manage and dynamically build the string I need (the business case is much more complex and...

Sue

Thanks for your suggestion. Just minutes before your post, I came across the solution. I really do not fully understand it (I think that even the person that...

Alan,

Thanks so much for the perfect solution you have provided. Works like a charm and will save us from having to write application code for the specific purpose.

One final...

I am attaching a file that contains (more or less) the entire submission that I am receiving (had to change file extention to TXT - because XML is not a...

Thanks all, once again. These are great solutions that I am studying to understand more... BUT... my problem is ALSO that the XML contains more than one <CustomField>... and I...

Thanks everyone! All solutions seem to work just fine... and I am inclined to work with this one (I still have to fully understand what it actually does)...

SELECT m.value('(text())[1]', 'varchar(100)')

FROM...

Thanks all for the answers and suggestions...

We believe that the problem is indeed related to someone importing data with some unspecified tool... but, of course, not one single user...

That was such a fast reply... thank you so much. The solution you propose is, indeed, just what I needed. I am only now starting to work with XML and...

Thank you all - and especially thank you Jeff. The solution you provided is exactly what I need.  Just as Sergiy pointed out, this table is the back-end data storage...

Remi and Chris -- thank you so much... that is a great solution... and by looking at your sample code I have learned something new and valuable.

Giorgio