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/