Creating Search Strings

Hello folks

I'm tring to create a search function on a page that searches a database fields. But the problem I am having is that, instead of a user typing in a key word, the have to type in the exact phrase to get a result from the db.

 For example...

With my current code, if a user wants to look for "newbie .net developers in ireland", they would have to type in that exact phrase. But i need to create a function, where the user only has to type in keywords to get a result. For example "developers london"

Heres my current codepublic static DataSet Searchgroup (string group_name)

{

SqlCommand cmd = new SqlCommand("select * from TG_User_Created_Groups where group_name =@group_name", conn);cmd.Parameters.Add(new SqlParameter("@group_name", group_name));

DataSet dst = new DataSet();SqlDataAdapter dtr = new SqlDataAdapter(cmd);

dtr.Fill(dst);return dst;

}

 

can anyone offer advise or know of any tutorials around that might demonstrate how I need to do this?

 

Cheers!