>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.

pName LIKE '%UP' OR pName LIKE '%DTC' OR pName LIKE '%SPM'

BTW this will probably have poor performance in a table with a large number of rows. For better performance, if possible you should precede the filter by some query that can be optimized e.g.

Where IndexedField > SomeVal_1 And IndexedField < SomeVal_2 ;
    AND ;
   (pName LIKE '%UP' OR pName LIKE '%DTC' OR pName LIKE '%SPM')