Time Nick Message 14:12 CabV Trying to write a report to find bib titles in ALL CAPS but UPPER function doesn't seem to work (title = UPPER(title)). 14:12 CabV Also played with the BINARY & COLLATE functions but didn't get anywhere. 14:51 CabV so this worked: title COLLATE utf8_bin = UPPER(title) COLLATE utf8_bin 20:45 barton evening alexbuckley 20:45 alexbuckley hi barton :) 20:46 barton I'm hanging out here hoping that someone who proposed a patch to bug 20:47 barton oops bug 5789 20:47 barton ... would show up. 20:48 barton wanted to walk him/her through dev process. 20:56 rangi morning 21:00 barton|laptop hi rangi! 21:01 barton|laptop my desktop linux box overheated *just* as I was finishing my last trouble-ticket for the day. :-P 21:01 barton|laptop luckly it was a report, and I'd just saved it. 21:22 barton|laptop added https://wiki.koha-community.org/wiki/SQL_Reports_Library#Items_with_orphaned_Locations , might be useful to somone.