Loading a numeric value with decimal point instead of comma

[#1]

Hi how would I load a field containing numeric values in the form 00.00 as opposed to how it currently stands ie 00,00 ?

Thanks

[sunny_talwar]

May be change these setting around:

SET ThousandSep='.';

SET DecimalSep=',';

[jonathandienst]

If you don't want to change the default values for the decimal and thousands separators, load the value like this:

    ...

     Num(Num#(myField, '#.##0,00', ',', '.')) As myField,

     ...

[#4]

Thanks Sunny - It works, however I should mention I only want to change it for this particular field ? I dont want it to affect what I currently have in other fields