The reason I used CAST(?myVar as same as SQL Server column definition) was primarily to avoid implicit conversion and therefore making the query non-sargable. I wanted to ensure that we're not doing any conversions for the column as float has higher precedence than numeric.