I am working on a query joining the customer order master, and the address master. I need to join on the company, the customer number, and the customer ship to address. However that column in the Customer order master seems like it has odd enoceding. Like it isn't codepage 37 or CSSID 65535. Column is C6B9CD.

Any ideas on the cause, or if this is normal. And then how would I convert only the coulmn to match a number that is in the address table?