23 Nov
2011
23 Nov
'11
10:50 p.m.
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