title: Convert a percentage(string, with a %) to a decimal in postgresql
body: <p>I would like to average on the Scores(string) of each person from the following table in postgresql,</p>
  <pre><code>No. | Name    | Term   | Score
  1   | A       | 1      | 95.00%
  2   | A       | 2      | 99.00%
  3   | C       | 1      | 90.00%
  4   | D       | 1      | 100.00%
  .
  .
  </code></pre>
  <p>It does not like % on the score. How can I convert it into a decimal/float from a string containing a % as shown above?</p>
  <p>Tried,
  <code>score::decimal</code>
  but it complains as,</p>
  <pre><code>ERROR:  invalid input syntax for type numeric: &quot;95.00%&quot;
  SQL state: 22P02
  </code></pre>
  <p><code>cast</code> also does not seem to work.</p>
  <p>How do I convert this?</p>