title: Convert Non-English text into English text using SQL
body: <p>I have text normalizing method, I use it to <strong>convert non-English letters into English letters</strong> only.</p>
  
  <h2>I need to do the same functionality using SQL server</h2>
  
  <hr>
  
  <p><strong>C# Method:</strong></p>
  
  <pre><code>  private  string normalizeString(string inputWord)
          {
              StringBuilder stringBuilder = new StringBuilder();
              foreach (char c in inputWord.Trim().ToCharArray())
              {
                  string normalizedChar = c.ToString()
                      .Normalize(NormalizationForm.FormD).Substring(0, 1);
  
                  stringBuilder.Append(normalizedChar);
              }
  
              return stringBuilder.ToString();
          }
  </code></pre>
  
  <hr>
  
  <p><strong>Example</strong></p>
  
  <pre><code>Ä =&gt; A
  ä =&gt; a
  Ö =&gt; O
  ö =&gt; o
  Õ =&gt; O
  õ =&gt; o
  Ü =&gt; U
  ü =&gt; u
  </code></pre>