Salvete! >SELECT >CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,2) > WHEN '19' THEN 'XX' > WHEN '20' THEN 'XXI' > WHEN '18' THEN 'XVIII' > WHEN '17' THEN 'XVII' > ElSE 'OLDER' END > AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m >GROUP BY bibtype > >I made this report based on two reports from the library by Nicole C. >Engard. >
Should prolly be > WHEN '19' THEN 'X1X' > WHEN '20' THEN 'XX' > WHEN '18' THEN 'XVIII' > WHEN '17' THEN 'XVII' yeah? Cheers, Brooke _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha