SQL Server 2008 r2中的XML查询/修改问题

I'm fairly new to SQL and I'm trying to filter and change the values inside of column that holds an XML document for a purchased order. Here's an example of what the XML document looks like and what I'm searching for. I'm fairly new to SQL and I'm trying to filter