nopCommerce 3.5 Get values out of Order CustomValuesXML

In nopCommerce 3.5 the Order.CustomValuesXML field is an nvarchar(max) datatype instead of an Xml datatype.  This makes extracting values such as the PO Number a little more tricky.

Here is a sql example to retrieve the Order Id and the PO Number.

--, x.value('key[1]', 'varchar(255)') the key
, x.value('value[1]', 'varchar(255)') as [PONumber]
from [Order]
Cross Apply (Select Convert(xml, CustomValuesXML))  cvXML(col)
Cross Apply cvXML.col.nodes('/DictionarySerializer/item') Result(x)