Hi,

I'm scratching my head trying to come up with a solution to this little problem.

I want to use soundex with some form of pattern matching on a string. If someone sends in an email saying "please play me a song by madonna thanks", I want to search the database for a matching record containing madonna in the artist field. Also, if they type in something like "please play me bitney speers for everyone that knows me" (sic) it'll find a matching record with Britney Spears in the artist field.

Figured out how to use soundex, but the rest is baffling me a bit!

Thanks,
Alex