Varchar to Float in SQL Server
declare @abc varchar(30)set @abc = '10.5'select convert(float,@abc)
declare @abc varchar(30) set @abc = '10.5' select cast( @abc as float)