A number of our packages have XML that is encrypted. Is there a quick way to add decryption to these queries?

I've been playing around a bit, but haven't found...

Thanks for the suggestion.  It looks as if this will only work if you switch the data to a table with only 1 partition.  I need 6 partitions.

I found the...