select top #_maxItems# opr.operatorid, opr.companyname, opr.city, opr.state 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 ) order by opr.companyname #_data#