I have a varchar field that contains SOAP requests i.e. XML. I'm trying to query the field by casting it as XML but occasionally the cast fails claiming that the XML is invalid.
I've tracked this down to an element that contains free text, in particular it contains the UK Pound symbol £. which is going to appear in the field as there will sometimes be payment information in it. I thought this was a valid character.
Does anyone know what's going on here or how I might work around it? I'm sort of guessing that even if I create an xml field to contain this content I am still going to have the same issue.
Insanity: doing the same thing over and over again and expecting different results.