Rob,

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




Return to Archive home page | Return to MIDRANGE.COM home page