select cityId , (code + ” + name) as generaldesc from tblCity where (deleted=false);