Check out this link:

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

Read in the file line by line into a table like it says and then you can search the table.