title: T-SQL converting string into float
body: <p>In a stored procedure on my SQL Server, I am trying to convert values from a varchar column into a float format.
  The values into the varchar column are numbers with a sign at the beginning and a '.' before decimals. </p>
  
  <p>Examples: '+0000000000000044.09' or '-0000000000114995.61' </p>
  
  <p>If I try this: <em>convert(float,mystring)</em>, it doesn't work.
  I have:</p>
  
  <blockquote>
    <p><em>Error converting data type varchar to float</em></p>
  </blockquote>
  
  <p>Is this kind of conversion possible?
  Or is there another way to convert a string with a sign and a '.' into a float?</p>