In RPG:

phwork = parta + '%' + partb + '%' + partc ;

... WHERE phonenbr like :phwork

"Alan Campin" <alan0307d@xxxxxxxxx> wrote:

Create a User Defined Function that accepts a phone number and returns
a
normalized values.


On Fri, Apr 8, 2011 at 11:15 AM, James Lampert
<jamesl@xxxxxxxxxxxxxxxxx>wrote:

I have a problem with phone number searching in a database.

The problem is that the phone numbers are not stored consistently.

Most U.S. phone numbers are stored with the punctuation squeezed out.
But there are a few that are stored including the punctuation.

Most non-U.S. phone numbers are stored "as-entered." But again, there
may be exceptions.

And we don't know which of these possibilities we're looking for
until
after we find it.

Is there an SQL construct, that works back to V4R4, in which, if
we're
given a raw value of, say, (714) 555-1212, we will find both "(714)
555-1212" and "7145551212" in the file?

--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
Sent from my Galaxy tablet phone with with K-9 Mail. Please excuse my brevity.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].