title: How to select name containg a specific letter in the first half of it?
body: <p>I wonder if you could help me figuring out of how I can select last name of a worker who has letter 'A' in the first half of his last name. By saying half I mean splitting the last name and picking up only the left part of it. For instance, let's take the last name 'Schwarzenegger' containing 15 characters. The query will fetch this last name as it does have letter 'a' in the first half of it (SCHWARZ-negger). If the last name is 'Jordan', then we are not interested in it since letter 'a' appears in the second half of the name (jor-DAN)</p>
  
  <p>Any help or hint would be highly appreciated.</p>
  
  <p>Cheers
  Andy</p>