title: SQL Query to search by name(containing combination of two or more word)
body: <p>When i search by using</p>
  <pre><code>....LIKE '%&quot; + txtName.Text + &quot;%'.....
  </code></pre>
  <p>Then it returns all the rows containing <code>txtName</code>. It is okay for name like</p>
  <ul>
  <li><p>Bijay or</p>
  </li>
  <li><p>Bijay kumar.</p>
  <p>And rows contains data like</p>
  </li>
  <li><p>Bijay,</p>
  </li>
  <li><p>Bijay kumar kush,</p>
  </li>
  <li><p>Bijay kush.</p>
  </li>
  </ul>
  <p>In this case it should return, <code>Bijay kumar kush</code> and <code>Bijay Kush</code> when search by using <code>txtName</code> like <code>Bijay Kush</code>. But not getting the output like this. It is empty when search by using first name and last name without supplying middle name.Here<code>txtName</code>is the Full Name text Box used for searching the name.I want to know where am I making the mistake.Any help would be appreciated. thanks in advance.I am using this type of query which doesn't return the result if searched without middle name as stated above.</p>
  <pre><code>...
  if (!String.IsNullOrEmpty(txtName.Text) &amp;&amp; !String.IsNullOrWhiteSpace(txtName.Text))
         SearchSqlDataSource.SelectCommand += &quot; AND (New_Employees.Full_Name LIKE '%&quot; + txtName.Text + &quot;%' OR New_Employees.Full_Name LIKE '%&quot; + txtName.Text + &quot;%')
  </code></pre>