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:
- 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)%' - 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)%')