postgresql7.1 select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year as term, dotlrn_terms.term_id from dotlrn_terms where dotlrn_terms.end_date > now() order by dotlrn_terms.start_date