Comparing PART of one string with PART of another 2

[DiggerDog]

Hi
I need to compare one string with another and if ANY part of the first string is in any part of the other string then I get a match.

E.g

Comparing "Elephant Ears" to "Grey Elephant" = true match
OR
Comparing "Grey Elephant" to "Earl Grey Tea" = true match
OR
Comparing "Earl Grey Tea" to "Teatime" = true match


Any help would be wonderful

thank you

 

[vongrunt]

General idea: split each string into table of words, then inner join these tables. Return true if there is at least one record present, otherwise false.

 

[johnherman]

Way to think outside the box, vongrunt !!
A star you are.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[DiggerDog]

Simple but effective - Works a treat Vongrunt
I agree with John - a star you are
thanks a million