MASTERTABLE.NUMBER LIKE '%1324940%'

##</code><code>##

   (   MASTERTABLE.SERIAL = 'FF' 
    OR MASTERTABLE.SERIAL = 'CC' 
    OR MASTERTABLE.SERIAL = 'OO' 
    OR MASTERTABLE.SERIAL = 'NN')