title: Extract data from the last two square brackets SQL
body: <p>So I am receiving some dirty data as resultset coming from a Cube, 
  Example :</p>
  
  <ul>
  <li>[Dates].[Fiscal Quarter].&amp;[2014Q3]</li>
  <li>[Geography Incl Profit Center].[Sub-Region1].&amp;[United States]</li>
  <li>[Geography Incl Profit Center].[Region].&amp;[NA]</li>
  </ul>
  
  <p>I am looking for a way to extract only what's inside the last two brackets,
  base on the last example I would need as end result the following:</p>
  
  <ul>
  <li><p>'2014Q3'</p></li>
  <li><p>'United States'</p></li>
  <li><p>'NA'</p></li>
  </ul>
  
  <p>these results are coming from 3 different columns, my idea is the find a way to position the index on the last '[' left square bracket, and delete anything that is on the left from it, then delete the last Character from the string which it should be ']'</p>
  
  <p>This is SQL, so any help on how to accomplish this will be excellent, </p>