I used the ASCII function to get the ascii code for Œ, which is 140 so write a function like so;

select * from tblXMLOrderLotShipping

where charindex(char(140),shipto) > 0

hope that helps.