from tbl_opr_clientoperators opr with (nolock) where opr.ownerid = and opr.fsltablecode = and opr.crmActive = 'Y' and opr.territoryId in ( ) and ( ( opr.companyname like or opr.city like ) and 1 = 1 )