This is what I have
This is what I need to do in one Filter In-DB:
ShipTosToAdd.[Customer Master Sold-To Name] not like '.%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like '% BU'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'Mitsubishi%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like '%Training%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'AIR PURIFIER%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'HVAC One%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'HVAC Multi%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like '%PLANT & WAREHOUSE'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'PARTS%'
or
ShipTosToAdd.[Customer Master Sold-To Name] not like 'COMPRESSS%'
It doesn't work so obviously my syntax is wrong.
Hi @latimo1
Try changing OR for AND
ShipTosToAdd.[Customer Master Sold-To Name] not like '.%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like '% BU'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'Mitsubishi%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like '%Training%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'AIR PURIFIER%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'HVAC One%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'HVAC Multi%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like '%PLANT & WAREHOUSE'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'PARTS%'
and
ShipTosToAdd.[Customer Master Sold-To Name] not like 'COMPRESSS%'
👍