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/