SELECT * FROM Companies WHERE Status>0 and AreaCode = '942' ORDER BY LNa