Re: SQL wildcarding

[Dennis <iseries@xxxxxxxxxxxx>]

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.