select statement to find a column which contains the word

hi,
I am trying to find out how to select a row of data from a table, where a column contains a keyword (from a querystring)
How would i write this select statement? I only want the column to contain a keyword, along with other words, rather than the columns only data is the keyword.
eg: the row below would be returned because column2 contains 'hello'

column2
asdasdaehelloasdasdads


thanks!

...