vb.net and sql reports

Question

am wondering if I can accomplish all and/or any of the following parts using vb.net 2008 or  vb.net 2010  and/or sql server reporting service 2008 R2:Take various company notes and directives and put them into a database table then be
able to search the data for keywords. The sql and/or ssrs 2008 r2 and/or the  C#.net application
must be able to do the following:
 a. Put all this data in one sql server 2008 r2 table,
 b. Have a method to input new rows of data,
 c. Have a method to search the existing data based on keywords.
Thus can you tell me the following:
 a. For the search,
  1. Are there any new lookup methods I can use in sql server 2008 r2, and/or 
  2. Would I a 'like' statemnt in t-sql, and/or
  3. Can I accomplish this in some way using ssrs 2008 r2 standard edition, and/or
  4. Would I need a vb.net application?
  For the items listed above, can you point me to a url to accomplish this tasks?
 b. For the whole process, can you tell me what would be the best way to accomplish this process?