title: Azure Stream Analytics - SQL to convert string to float
body: <p>What is the easiest way to convert a string to a float in the Azure Stream Analytics job service query? Unfortunately, I'm quite new to SQL, but only need this conversion applied to the CSV data stream.</p>
  
  <p>This is what I get from the Test option on the query page...</p>
  
  <pre><code>'DeviceID','Temperature'
  '20','30.8'
  '20','32.1'
  '20','31.5'
  '20','28.2'
  '20','29.1'
  </code></pre>
  
  <p>...when I use...</p>
  
  <pre><code>SELECT *
  INTO TempPowerBI
  FROM Tempiothub
  </code></pre>
  
  <p>... but in Power BI, the numbers can't be displaced. Instead, the amount of data is counted. So I guess the Stream Analytics query is the best place to convert the data.</p>
  
  <p>Thanks a lot in advance ~</p>
  
  <p>M.</p>