select cho_id, cho_type, cho_name from tbl_CHO_Operators with (nolock) where cho_type = and ( ( cho_name like ) and 1 = 1 ) order by cho_name #_data#