title: Removing Tabulation from Firebird
body: <p>I'm trying, but I can not seem to get a tab at the end of a varchar in Firebird. Does anyone know how to do it?</p>
  <p>To be more specific:</p>
  <pre><code>Select guia, convenio, nome, trim (matricula) from table where guia = '142'
  Group by guia, convenio, nome, trim (matricula)
  </code></pre>
  <p>The result</p>
  <pre><code>142 | 1 | Name of patient | 111222
  142 | 1 | Name of patient | 111222
  </code></pre>
  <p>However, if I remove the enrollment field, which is a varchar(40) which is with the tabs:</p>
  <pre><code>Select guia, convenio, nome, matricula from table where guia = '142'
  Group by guia, convenio, nome
  </code></pre>
  <p>The result is:</p>
  <pre><code>142 | 1 | nome do paciente
  </code></pre>
  <p>And as I discovered that the problem was enrollment:</p>
  <p>With the help of this function: <code>char_length(matricula)</code></p>
  <pre><code>Select guia, convenio, nome, matricula, Char_Length(matricula) from table where guia = '142'
  Group by guia, convenio, nome, matricula
  </code></pre>
  <p>The result:</p>
  <pre><code>142 | 1 | nome do paciente | 111222 | 6
  142 | 1 | nome do paciente | 111222 | 10
  </code></pre>