SQL To update a text value with xml inside of the column.
For example...and please note...the node I need to change will never be in the same order.....and will not have the same date value.
Here is the example. Note I need to change the DATEPASSCHANGE value to todays date....regardless of the date.
So I guess I need some query that will find the node...as it could be anywhere in the string....and then take whatever the value is and make todays date.
Please help...I only know how to do this with one value if I knew what the value I was changing was and I have thousands of these records in different orders with different dates.