<html>
<body>
<font size=3>At 08:08 AM 12/2/2005, John Stires wrote:<br>
<blockquote type=cite class=cite cite="">One of my coworkers has been
rather perplexed with NCONVERT. He is attempting to convert a
number with a decimal component. Instead of getting a numeric with
the decimal component still intact, he is getting in integer
number. He has tried using NUM and FLOAT for the receiving defined
field. Both with the same results. <br>
</blockquote><br>
It would be helpful to see the NCONVERT construct. I've used it in
PH 8.39 on HP, typically in a define something like this:<br><br>
<x-tab> </x-tab>DEFINE
D-AMOUNT CHAR*12 = NCONVERT(AMOUNT /100,
"#,###,###.##","-####,###.##")<br><br>
Dividing AMOUNT by 100 is necessary on the HP due to the numbers being
stored as integers. If your storage format includes the decimal
value, you don't need to do the division.<br><br>
John<br>
</font></body>
<br>
<div>------------------------------------------------------------------</div>
<div>John Pearce <jlpearce@adelphia.net></div>
Colorado Springs, CO USA
</html>