title: SQL - Select all person whose "firstName lastName" contain a name
body: <p>I have a database table "person" with two columns firstName and lastName. Now I want to select all the persons whose "firstName lastName" contains a given name. How can i do it with a SQL query?</p>
  
  <p>Example:</p>
  
  <p>Person x with firstName: A B and lastName: C</p>
  
  <p>Person y with firstName: A and lastName: B C</p>
  
  <p>Person z with firstName: A B and lastName: C D</p>
  
  <p>All of these persons should be shown in output if the query is with a criteria that the fullName (firstName lastName) contain B C</p>
  
  <p>The table was designed that it does not have fullName column.</p>