>Hi.
>I have a report that shows the result of a function that is applyed to a numeric value in a table. The function returns the accountant representation to a numeric value into a string, i.e:
>1234567.89--->1,234,567.89
>-1234567.89--->(1,234,567.89)
>
>When i open the resulting .doc file with MSWord, it shows the non-applyed function as if it were a literal field instead of the resulting value, i.e:
>
>myfunction(myvalue)
>
>Can somebody help me with this???
Use TRANSFORM(); there's no need for a UDF to accomplish this:
TRANFORM(nMyNumber, '@( 9,999,999,99')
If you want to eliminate any embedded spaces:
STRTRAN(TRANFORM(nMyNumber, '@( 9,999,999,99'),' ','')