> SELECT * FROM my_table
> WHERE my_column LIKE "*example*"

Either
WHERE my_column LIKE '%example%'
or case insensitive
WHERE my_column CONTAINING 'example'

(use single quotes for strings)

Ivan
http://www.volny.cz/iprenosil/interbase