Varchar to Float in SQL Server

Convert function can be used to convert your varchar value to Float.

declare @abc varchar(30) set @abc = '10.5' select convert(float,@abc)

Cast function will perform the same operation.

declare @abc varchar(30) set @abc = '10.5' select cast( @abc as float)

Cheers,

Venkatesan Prabu .J
Head - WWW.Kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/