×
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.
I believe tha TRANSLATE does allows for this, using the PAD parameter.
Something like:
SELECT text, TRANSLATE(text, '+', '1234567890', '+') FROM textfile
Would return:
TEXT
TRANSLATE
John Doe's bank account ABA 123456789 John Doe's bank account ABA
+++++++++
All deliveries to this customer after 1 pm All deliveries to this
customer after + pm
Sally's bank acct: 777888999 Sally's bank acct:
+++++++++
Wrong number 12345678900 Wrong number
+++++++++++
So if Joel's data is delimited with spaces it would be, as you wrote, very
easy to use the LIKE function. All the same, I concur that a RPGLE or a SQL
function would be a better solution (easier to implement and use).
Best Regards,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
As an Amazon Associate we earn from qualifying purchases.
This thread ...
RE: SQL select records with numeric strings, (continued)
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
