title: Find ONLY Capital Letters in word through IN SQL Server query
body: <p>I have to do this in SQL Server</p>
  
  <p>I have data such as</p>
  
  <pre><code>Belo Horizonte , MG - Brazil
  São Paulo , SP - Brazil
  Barueri , SP - Brazil
  Ferraz de Vasconcelos , SP - Brazil
  </code></pre>
  
  <p>I need to select two letter word as that matches the pattern </p>
  
  <pre><code>Space Letter Letter
  </code></pre>
  
  <p>I have tried this</p>
  
  <pre><code>SUBSTRING(ADDRESS_BLOCK,PatIndex('% [A-Z][A-Z] %',ADDRESS_BLOCK),3)
  </code></pre>
  
  <p>But I need to consider only capital letters for this (i.e) output has to be</p>
  
  <pre><code>MG SP SP SP 
  </code></pre>
  
  <p>And not include <code>de</code> as found in the last line of the example <code>Ferraz de Vasconcelos , SP - Brazil</code></p>
  
  <p>Clear view on the problem</p>
  
  <p>Eg: vaishnava st northwind GH -- Result has to be GH</p>
  
  <pre><code> somersert PM vailash hj  --Result has to be PM
  </code></pre>