Searching a SQL Server DB..??..

I am creating a online forum in ASP.Net written with C#. I am wondering if anyone has recommendations on how to set up a search so I can search based on users keywords entered. I am thinking that I would need to create ad hock queries or something like that, but would rather use stored procedures so they can execute a little faster. The options I am giving are much like the options included on the search page of this forum.

Anyone have any search code writing experience they can share with me....or even better yet, code (C#, VB.Net, Stored Proceedure.....doesn't matter). I welcome all help and advice anyone could give. Thanks.