Num#()

[#1]

Hi All,

I was trying to convert a value which is in text format to number using NUM#() but i am not getting the expected value.the value is in the below format

66.99072
67.2913
67.6825
67.29164
67.37867
67.40173
67.58928
67.59046

Plz any one help on this.

[sivarajs]

Try this

LOAD num( EVALUATE(No),'#0') as Num_Data from abc.qvd;