×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Both of these give me a not found:
select 1
from SYSIBM.SYSDUMMY1
where replace('0110 EXFN 01','_','\_') concat '%' like '0110 EXFN 01
ABCD' escape('\')
select 1
from SYSIBM.SYSDUMMY1
where replace('____ EXFN 01','_','\_') concat '%' like '0110 EXFN 01
ABCD' escape('\')
I was wondering if a starts-with kind of match would work. These seem to
do the trick.
select 1
from SYSIBM.SYSDUMMY1
where locate('0110 EXFN 01', '0110 EXFN 01 ABCD') = 1
select 1
from SYSIBM.SYSDUMMY1
where locate('____ EXFN 01', '0110 EXFN 01 ABCD') = 1
Thanks
date: Tue, 19 Oct 2021 13:10:23 +0000
from: Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
subject: Re: LIKE quandary
replace(t2.column,'_','\_) concat '%' like t1.column escape('\')
untried and off the top of my head.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
