title: Full text search on multiple columns sql server
body: <p>I have the following table </p>
  
  <pre><code>Id  Author
  1   Alexander Mccall Smith
  2   Ernest Hemingway
  3   Giacomo Leopardi
  4   Henry David Thoreau
  5   Mary Higgins Clark
  6   Rabindranath Tagore
  7   Thomas Pynchon
  8   Zora Neale Hurston
  9   William S. Burroughs
  10  Virginia Woolf
  11  William tell
  </code></pre>
  
  <p>I want to search the Author by putting first few characters of the first and last name.</p>
  
  <pre><code>eg: Search Text: Will tel
  Then the search result show the following result
  </code></pre>
  
  <p><strong>Will</strong>iam <strong>tel</strong>l</p>
  
  <pre><code>eg: Search Text: will Burrou
  Then the search result show the following result
  </code></pre>
  
  <p><strong>Will</strong>iam S. <strong>Burrou</strong>ghs</p>
  
  <p>eg: Search Text: Will
      Then the search result show the following result</p>
  
  <p><strong>Will</strong>iam S. Burroughs
  <strong>Will</strong>iam tell</p>
  
  <p>What is the efficient way to achieve this in sql server ? </p>