- Moderator
- #1
Is there a (simple, preferably) way to parse XML that is stored in a field in a recordset?
In other words, I have a table that has XML data in one of the fields, such as <UserName>Ralph</UserName><Whatever>Something else</Whatever>...
So, is there a way to essentially do a "Sub-query" of the field with the XML in it?
SO, something like:
SELECT Field1, Field2 { SELECT UserName FROM Field3 AS XML } AS Username
... something along those lines? (I know that query didn't make sense... but I'm just trying to get my point across.)
Thanks in advance.
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
In other words, I have a table that has XML data in one of the fields, such as <UserName>Ralph</UserName><Whatever>Something else</Whatever>...
So, is there a way to essentially do a "Sub-query" of the field with the XML in it?
SO, something like:
SELECT Field1, Field2 { SELECT UserName FROM Field3 AS XML } AS Username
... something along those lines? (I know that query didn't make sense... but I'm just trying to get my point across.)
Thanks in advance.
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg