Yes That is the exact way I need the SQL WHERE as It's not always A.It could be any prefix and followed by complete CLNAME. AND CLName LIKE('A%','MET-CL1',BDO-CL1'). But If there is no prefix, then it should work for AND CLName LIKE('ATN-CL1','MET-CL1',BDO-CL1') as well. Thanks