>Hi.
>
>Does anyone know of a class that'll do pattern matching. Here's the reason why.
>
>Let say I want to link 2 files.....but there are inconsistencies in the primary field. What I'll like to do is have a class that'll take part or the whole record and try pattern matching return a probability that the two records are related.
>
>Thanks
For text, the SOUNDEX() and DIFFERENCE() functions might be helpful.