'Match any' lookups

[VirtualBob]

I'm creating a rough and ready budgeting database. I'm downloading my bank statements and what I want is a lookup the matches a keyword wherever it appears in the description field.

So if the description field says:

Budget Supermarket

The match keyword is:

Supermarket

This won't work in a classic lookup in FMPro 7 as it only likes one word in the description field.

So I'd like something like:

Franks Auto Repairs = Auto

Budget Petrol = Petrol

Beer Barn = Beer

Any ideas how I would achieve this