This function allows you to specify multiple values that follow a given pattern within a field. The field could be anything: titles, marc fields or subfields, LC classes in call number, etc.

The syntax is: <field containing the values> similar to '(list each value separated by a | symbol)'. Add wildcard characters where needed.

Examples:

  1. Find titles where the following terms occur: ASTM, AASHTO, ASHRAE, ACI, ISO, ANSI, ASME, SAE or AWS. 

    instext.title similar to '%(ASTM|AASHTO|ASHRAE|ACI|ISO|ANSI|ASME|SAE|AWS)%'

  2. Find selected bib format codes contained in the "000" field of the instance record. The format codes to look for start with "a", "t", "c" or "d".

    sm.field = '000' and (substring(sm."content", 7, 2) similar to '(a|t|c|d)%')
  • No labels