title: To get the position of a letter from a (column)string in a table
body: <p>I have a database  employee as</p>
  
  <h3>EMPLOYEE_ID FIRST_NAME  LAST_NAME   SALARY      DEPARTMENT   JOINING_DATE</h3>
  
  <pre><code>      1       John      Abraham     1000000      Banking     2013-01-01
        2       Michael   Clarke      800000       Insurance   2013-01-01 
        3       Roy       Thomas      700000       Banking     2013-02-01 
  </code></pre>
  
  <p>My Query is to :<strong><code>Get position of 'o' in name 'John' from employee table!</code></strong> in postgresql!</p>
  
  <p>I have tried with :: <code>SELECT position('o' IN 'John');</code> But I want to get John from the table! is there a way to doing so?</p>