I seem to be having an issue with the query below. It's returning 0 results in Marketing Cloud where locally I'm getting the correct number which is 19. I also tried using an EXISTS clause and am getting the same problem. What am I missing here?

    SELECT * FROM [Abandoned Cart Import from FTP]

    WHERE 

    'UPS' IN (ShippingMethod_ref1, ShippingMethod_ref2, ShippingMethod_ref3, ShippingMethod_ref4, ShippingMethod_ref5, ShippingMethod_ref6, ShippingMethod_ref7, ShippingMethod_ref8)

    AND 'INH' NOT IN (ShippingMethod_ref1, ShippingMethod_ref2, ShippingMethod_ref3, ShippingMethod_ref4, ShippingMethod_ref5, ShippingMethod_ref6, ShippingMethod_ref7, ShippingMethod_ref8)

    AND 'UP2' NOT IN  (ShippingMethod_ref1, ShippingMethod_ref2, ShippingMethod_ref3, ShippingMethod_ref4, ShippingMethod_ref5, ShippingMethod_ref6, ShippingMethod_ref7, ShippingMethod_ref8)