title: How to get middle character from a string using SQL Server?
body: <p>I have a table like this.<br></p>
  
  <pre><code>----------------
  |Id  | Name    |
  ----------------
  |1   |Apple    |
  |2   |banana   |
  |3   |Orange   |
  |4   |Grapes   |
  |5   |Mango    |
  ----------------
  </code></pre>
  
  <p>I need middle character from each string.My result is to be like this</p>
  
  <pre><code>--------------------
  |Id  | Name    |MidChar|
  ------------------------
  |1   |Apple    | p |
  |2   |banana   | n(or)a|
  |3   |Orange   | a(or)n|
  |4   |Grape   | a |
  |5   |Mango   | n |
  -------------------
  </code></pre>
  
  <p>Please give some solutions or ideas.</p>