public static void Main()
Console.WriteLine(GetResults("Hello World"));
private static string GetResults(string searchTerm)
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM [MyTable] ");
var terms = searchTerm.Split(' ');
foreach(string t in terms)
string temp = string.Format("[Title] like '%{0}%' or ", t);
var res = ReplaceLastOccurrence(sb.ToString(),"or","");
public static string ReplaceLastOccurrence(string Source, string Find, string Replace)
int place = Source.LastIndexOf(Find);
string result = Source.Remove(place, Find.Length).Insert(place, Replace);