I have been trying to use the LIKE filter without success.

I am looking for records that have in pName 'UP' or 'DTC' or 'SPM'

using: pname LIKE 'UP' or pName LIKE '%UP' (single instance) is sucessful, however the following EX: is not.

EX: pName LIKE '%UP%DTC%SPM%'

Any help on syntax would be appreciated.