SELECT * FROM Companies WHERE Status>0 and LState = 'KS' ORDER BY LCi