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