alternative way to Search for a word within field

[nuct]

Hi, here is the problem:

I have a field with this type of data:

BA (Hons) Costume Design
HND Graphics Design

And I want to make it so that someone can bring up these records by searching this field with things like 'Costume', or 'Design'. I have got it to work in SQL+ using this:

AND COURSE_NAME LIKE '%&COURSE%'

but that line doesn't work within our reporting tool, so i need to find another way.

Any ideas?

Simon.