yes,

SELECT CAST('1D2' AS FLOAT);

when I ran this query it ran successfully and gives 100 in output.. I dont know how it cast it to 100 :w00t:

While when I ran this one

SELECT CAST('1D2' AS INT);

it gives an error of datatype conversion...