select top #_maxItems# opr.cho_id as operatorid, opr.cho_name as companyname, opr.cho_city as city, opr.cho_state as state from tbl_CHO_Operators opr with (nolock) where 1 = 1 and ( ( opr.cho_name like or opr.cho_city like ) and 1 = 1 ) order by opr.cho_name #_data#