Re: SQL wildcarding

[Alan Campin <alan0307d@xxxxxxxxx>]

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.