Originally Posted by Sand_Devil

If I understand what you are suggesting... word being the entered string and blah_field being the database entry. || allows you to concatenate strings. To search for the % you need to place an escape, usually \

where word like ('%'||blah_field)

Should do the trick.