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