topic Currency in Application Development and Automation Discussions

Currency

Former Member — Tue, 03 Jun 2008 14:38:29 GMT

Hi-

I need to concatenate parentheses for $ amount.

For example

32,256.36- Should be (32,256.36)

The date type is CURR.

what i did is i moved it to Char type and concatenated but when i write i am not getting the commas separated $ amount value.

Former Member — Tue, 03 Jun 2008 14:40:52 GMT

write as ..

write v_amount to v_char. "--> 32,256.36- to v_char

concatenate '(' v_char ')' into v_char1.

write v_char1.

Former Member — Tue, 03 Jun 2008 15:17:53 GMT

Thanks.