Skip to main content
Ex Libris Knowledge Center

Finding bib records with multiple occurrences of field


  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care


How can I find bib records with multiple 949 fields (or multiple occurrences of some other field)?


If you have the z00r, SQL will give you this. Here's a search for multiple 949 fields:

abc01@ALEPH20> select Z00R_DOC_NUMBER from z00r where z00r_field_code like '949%' group by Z00R_DOC_NUMBER having count(*) > 1 order by Z00R_DOC_NUMBER;



  • Article last edited: 12-Mar-2016
  • Was this article helpful?