How to convert varchar to float ?

[bhaveshp90]

Hello All,

I have a column Risk_Contingency which is varchar. How can I convert this into float, I am also replacing the ',' with ' '.

Below is my SQL query for this

              Convert(float, replace([Risk_Contingency_WBS], ',',''))  as Risk_Contingency,

any help is greatly apprecaiated,

thanks

Bhavesh

[vishsaggi]

So what is the issue with your convert function? Is it not converting to float?

[bhaveshp90]

It is converting to float in SQL, but I am trying to write the same logic in QlikView (in my expression)

[trdandamudi]

See if the below link helps...

convert a float field to integer

[vishsaggi · Accepted solution]

May be use Num() function like

Num(Trim(replace([Risk_Contingency_WBS], ',','')), '#,##0.00')

What are the values in your RiskContingency field?