Boy, I've been researching this subject, but I am just not getting it. Sorry if I'm asking a question that has all ready been asked a million times, but its hard to understand when you're a noob like me, and the values in my tables aren't like the others I've seen. So here it goes...
In my SQL Server database, I have a table that has all my listings in it, called ItemsEbay.
(The main identifier for each individual item has a column named ItemID.)
Within the ItemsEbay table is a column named ItemSpecifics that contains XML data. Within the ItemSpecifics XML Data, is a node with a <Name> of UPC, and text and random <value> for that node:
What I would like, is a query that would allow me to search all the items in the ItemsEbay table that have a specific UPC "value" of my choosing, such as TEST10, or 10U100 for instance.
When the query finds the matching values I'm looking for, I would like to be able to replace them all at once with a new value "Does Not Apply."
Any help would be greatly appreciated.