Filter In-DB Tool Need Multiple Filters using OR

latimo1

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.  

Felipe_Ribeir0

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%'