This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Sander van Zoest, This is a computer-generated report for MP3-ID3v1Tag-1.11 on perl 5.10.0, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester comments * ...

... as a starting point: SELECT Numbers.number, Tariffs.code ; FROM Numbers LEFT OUTER JOIN Tariffs ON Numbers.number = trim(Tariffs.number); WHERE !empty(Tariffs.number); AND NOT EXIST ; (SELECT * ; FROM Tariffs AS iT ; WHERE iT.number = trim(Tariffs.number) ; AND len(trim(iT.number)) len(trim(Tariffs.number)); ) In words: exclude all result rows if there exists a longer Tariff number. Regards Bernhard Sander

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Stan Sander, This is a computer-generated report for Device-Davis-1.2.3 on perl 5.10.0, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester comments * ...

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Sander van Zoest, This is a computer-generated report for MusicBrainz-TRM-0.02 on perl 5.8.8 patch 34313, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester ...

...), that certainly wouldn't be bad if it was the only way. Regards Mark In article <#aSNhNBFJHA.4712@TK2MSFTNGP02.phx.gbl>, Bernhard Sander wrote: Hi Mark, I'm sorry if it was confusing, I think these are the relevant parts of the tables. ..., if there are number entries in TARIFF like 087 0871 since the first entry will also match the telefon numbers that start with 0871 Regards Bernhard Sander

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Sander van Zoest, This is a computer-generated report for MusicBrainz-Client-0.11 on perl 5.8.8 patch 34313, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester ...

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Sander van Zoest, This is a computer-generated report for MusicBrainz-Queries-0.11 on perl 5.8.8 patch 34313, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester ...

... JOIN Tariffs ON ; left(Numbers.number, len(trim(Tariffs.number)) = trim(Tariffs.number) ; WHERE !empty(Tariffs.number) LEFT OUTER JOIN returns .NULL. as Tariffs.code for every row in Numbers where there is no matching row in Tariffs. You will get unexpected results, if there are number entries in TARIFF like 087 0871 since the first entry will also match the telefon numbers that start with 0871 Regards Bernhard Sander

This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ -- Dear Sander van Zoest, This is a computer-generated report for MusicBrainz-TRM-0.02 on perl 5.10.0, created by CPAN-Reporter-1.17. Thank you for uploading your work to CPAN. Congratulations! All tests were successful. Sections of this report: * Tester comments *...

RushMore is Your Friend. Make an index that matchs whats forming in the substring. then do another query based on that substring. -- =================== William Sanders / EFG VFP / mySql / MS-SQL www.efgroup.net/vfpwebhosting www.terrafox.net www.viasqlserver.net "Mark Stanton" <mark@dont.spamme.invalid> wrote in message news:VA.00000007.0fc74e60@dont.spamme.invalid... I've got a table with a column of telephone numbers that...