SQL search in Z30_CALL_NO $$k subfield

• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Description:
Is there a way to find a word, anywhere in the call number, Z30_CALL_NO $k subfield?
I need to find "po" when in the $k. It could be anywhere in the subfield.

These should be found :

$$kPGI poQUEBEC$$hA11F341 L36 1995
$$kPGI$$kPeriodiques$$kpoCANADA$$hZ1-1991/ X2-11F

This should not:

$$kPGI$$kREF$$kPeriodiques$$hpoCWLTH eCWLTH

Resolution:
The following SQL can be used:

abc50@ALEPH20> select z30_rec_key, z30_call_no from z30 where z30_call_no like '$$k%po%$$h%';

(This SQL requires that the "po" occur after the $$k and before the $$h.)

• Article last edited: 12-Mar-2016