Sql query with partial matching

How would I write an sql statement which would select all the
records from a table where some string field contains
some substring?  Example: find all the records where f1 contains
the world "cool."


Thanks,

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------