Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Find titles beginning with *

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    We need to find the titles in our bib database that actually have an asterisk as the first character in the 245 field.

    Is there a way to do that?

    I can think of three ways to do this:

    1) Searching the z00r table via SQL. The regular (z00) bib table is not searchable via SQL because the data is in Binary Long OBject format. The z00r is an optional table which has the data in an SQL-readable form. You do not currently have this table. See KB's 8192-5719 and 8192-9560 for the pros and cons of adding the Z00R.

    2) Running p_ret_01. It's possible that searching for the 245 tag, subfield a, with * as the From Text and *Z as the To Text could work, but I have not actually tried this.

    3) The third definitely works on your server:

    > s+ abc01
    abc01@ALEPH18> select z01_display_text from z01 where z01_display_text like '$$a*%' and z01_rec_key like 'TIT%';

    (Note: Your library may use "TTL" instead of "TIT" -- in which case the final string would need to be 'TTL%' .)

    • Article last edited: 10/8/2013