using System;

using System.Text;

public class Program

{

    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(' ');

        if(terms.Length > 0)

        {

            sb.Append("Where ");

            foreach(string t in terms)

            {

                string temp = string.Format("[Title] like '%{0}%' or ", t);

                sb.Append(temp);

            }

        }

        var res = ReplaceLastOccurrence(sb.ToString(),"or","");

        return res;

    }

    public static string ReplaceLastOccurrence(string Source, string Find, string Replace)

    {

            int place = Source.LastIndexOf(Find);

​

            if(place == -1)

               return Source;

​

            string result = Source.Remove(place, Find.Length).Insert(place, Replace);

            return result;

    }

}