title: Excel & SQL: How to convert string to double in Select statement
body: <p>I have a sheet in Excel. One column in it ("ID") contains strings with values: 1.01, 1.02, 1.03, 2.01, 3.01, 3.04 etc.</p>
  
  <p>I want to get all rows in that sheet, where "ID" is >= some value using SQL statement and ADO 
  connection (from VBScript code). 
  So, I have two questions:</p>
  
  <p>1) Can I convert ID's values to double in SQL? So, then I can compare  values as floating point numbers and apply &lt; and > conditions. 
  2) Can I use in select statement Macro from Excel workbook?</p>