title: SQL query to get names containing a and b anywhere in the string
body: <p>I would like to query my database to get the names of employees which contain both the characters <code>a</code> and <code>b</code> anywhere in their name string.</p>
  
  <p>I tried the following SQL query, but it did not return all the names that match the criterion I stated above.  How can I change it to return the names I want?</p>
  
  <pre><code>select FName
  from Employee
  where FName like '%a' AND FName like '%b'
  </code></pre>