Voyager to Alma Migration Query: Bibliographic Records containing multiple $a subfields in the 020

When migrating from Voyager to Alma, it may be desireable to identify those bibliographic records that have 020 fields with mutliple subfields $a in them.  Current MARC standards dictate one $a per 020 field.

This query, which can be run using Voyager Prepackaged Access Reports, identifies those bibliographic records with more than one $a subfield in an 020 field.

To correct this problem, you may want to manually edit the record.

SELECT BIB_TEXT.BIB_ID, utf8to16([ISBN]) AS ISBNs, utf8to16([NETWORK_NUMBER]) AS OCLC
FROM BIB_TEXT
WHERE (((utf8to16([ISBN])) Like "#########*#########*"));

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
 
If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.