title: Query to get all those names of employees,who have 'A' as their middle character in their name
body: <p>E.g:- BRAKE,CRANE etc.</p>
  
  <p>In my employees table , I have <code>ENAME,ENO,JOB,SALARY</code>.</p>
  
  <p>Here, I want to extract out those enames that have an 'A' as the center character in their name.</p>
  
  <p>If length of ename is odd,then center one, so i need to detect odd and even position in ename.</p>
  
  <p>So, I tried this, but stuck up ,so can i expect a help from  here?</p>
  
  <pre><code>SELECT ENAME
  FROM EMPLOYEES
  WHERE A IN
  (SELECT ENAME,
         SUBSTR(ENAME,LENGTH(ENAME)/2+1,1)
  FROM EMPLOYEES)
  ;
  </code></pre>