Michael Stassen wrote:
Anyway, I just wanted to share these observations with the original
poster - and anyone else on the list who is following this issue - to
help put some perspective on the matter. Again, feel free to ignore me
if you like. :-)
All good points. As you say, if the numbers are user entered, they
almost certainly contain garbage. On the other hand, he could be
processing logs of actual calls, in which case the numbers would almost
certainly be complete.
For God's sake, guys, trim your posts!
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.
--
Jasper Bryant-Greene
General Manager
Album Limited
+64 21 708 334
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
