Hartman, David W. - GBTS Library schreef op wo 23-11-2011 om 10:07 [-0500]: > Is there a command in SQL to convert my all CAPS subject heading to > proper? Or Koha? Thanks in advance for any help!
There is 'lower' and 'upper', but I'm not aware of anything in MySQL which does the equivalent of 'proper'. Also, I think the subjects are in MARC rather than a database table, in which case it'd be hard to do from plain sql anyway. It might be necessary to write a small perl script to do it. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
