title: Convert Text To Varchar
body: <p>In <code>Postgresql</code> how do you convert a text field to a varchar?  I have tried both of the below, but neither convert my text field to varchar.</p>
  
  <pre><code>Cast(Iamtextfield As Varchar)
  Char(Iamtextfield)
  </code></pre>