Page History

This function operator 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.

*** NOTE: the "similar to" operator is case-sensitive. If you have mixed-case values, use the "lower" operator (or "upper" operator) on the value string to convert the values to lower or upper case.

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

...

1. Find titles where the following terms occur: ASTM, AASHTO, ASHRAE, ACI, ISO, ANSI, ASME, SAE or AWS. 
   
   instext.title similarto'%(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) similarto'(a|t|c|d)%')