Jasper Bryant-Greene wrote:
> For God's sake, guys, trim your posts!
Sorry.
> Michael's solution will not produce reliable results as it will return
> at least two results for many different phone numbers, with no way to
> tell which is the correct result.
Really? As I said, I don't claim to be an expert on phone numbers, but if
they're ambiguous, how do they work? That is, if a number can start with a
valid prefix for two different places, where does the call go? Surely, there
must be a way to parse a phone number that correctly directs the call. The
question then becomes, how can we implement that method in mysql? Do you have a
solution?
Michael