How to find patrons with bad barcodes (-- beginning with non-numeric character)
Versions: 20, 21, 22, 23
Description
How can we locate patrons who have barcodes beginning with a non-numeric character?
Resolution
Run the following SQLs in the $usr_library:
SQL> select z308_rec_key, z308_id from z308 where z308_rec_key like '01%' and substr (z308_rec_key,3,1) < '0';
and:
SQL> select z308_rec_key, z308_id from z308 where z308_rec_key like '01%' and substr (z308_rec_key,3,1) > '9';