ASP Keyword Search

hi guys, am really struggling on this one - all i require is a simple ASP keyword search i.e user completes a search form, posts back to the page with the results.

Logic is easy enough but am not too sure on how should be handling the SQL in terms of i can filter by the search word easy enough but this isnt going to check if its contained within surely will just check for exact matches?.

Have had a nosey round for some examples on the net and have come unstuck hence the post here. Anyone Help?