How about the query from table

ie I have the whole file in column of a table then how would the query look like

I have a table --tblXMLData which has XMLData...

Once again thank you so much Jesse for your detailed explanation, now I understood as to how the query works for different scenarios.

Thank you so much.

Thank you so much Jessy for your help.

But in detail table, i just get only 1 row(everything is in one record only)instead of many rows, if the input has...