AND (      CLName LIKE 'A%'
        OR CLName LIKE '%MET-CL1%'
        OR CLName LIKE '%BDO-CL1%'
    )
[download]

As the OP is working a postgres derivative: in postgres (like perl, a bit TIMTOWTDI) that could be written:

AND CLName LIKE ANY (array['A%','%MET-CL1%','%BDO-CL1%'])