NCONVERT text with decimal fractions

James B. Byrne byrnejb at harte-lyne.ca
Fri Oct 28 10:01:00 CDT 2022


How does one convert a FIELDTEXT string containing a decimal fraction to a
FLOAT value? NCONVERT(FIELDTEXT) returns the integer value and truncates the
fraction.


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB at Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3



More information about the powerh-l mailing list