title: teradata get varchar representation of a float value
body: <p>I am trying to select float values as varchar strings (for flat file export).
  Have found several useful examples but none that seem to exactly match.</p>
  
  <p>We have many different values in the data, that should all show up correctly and remain exactly how it was</p>
  
  <p>e.g.,</p>
  
  <p>23.30  should not become 23.3<br>
  23.0   should not become 23. or 23<br>
  23     should not become 23. or 23.0<br>
  23.33  should not become in 23.3300</p>
  
  <p>many thanks for the help&amp;time.</p>