Here is a link to a C# algorithm (source and explaination) for determining a Longest Common Substring.

http://www.codeproject.com/cs/algorithms/lcs.asp

The Longest common substring is exactly what I am looking for.

Look as if I am not the first in need of such a function.

Thanks to all for your help

My two tables contain thousands of announcements and I need to run a query/procedure that will match entries on the Date fields between the two tables and then compare announcemenet...