Converting text to number

[Pickering, John (NORBORD)]

Jamie

Since PH doesn't know where the decimal places are in the result field it
assumes there are none and rounds the numeric value and gets zero. If you
want to save such a number you'll need to multiply the results of nconvert
by some power of 10 appropriate for the implied decimals in your target item
-- e.g. 1000 in this case.

Regards,
JWP

> -----Original Message-----
> From:	Jamie Harwood [SMTP:jamie.harwood@caddock.com]
> Sent:	Friday, October 19, 2001 4:42 PM
> To:	powerh-l@lists.swau.edu
> Subject:	Converting text to number
> 
> Hi - perhaps I am missing something, but I am trying to get the correct
> numeric value from a text field that may be something like 0.020. If I
> just
> use NCONVERT, it returns 0. Any help? Thanks!
> 
> Jamie Harwood
> 
>