Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Find titles beginning with *

    Find titles beginning with *

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    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?

    Resolution:
    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Find search return zero result.
      • Find Znn Tables Containing Patron ID in Order to Change an ID
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved