Jeff & Magoo,

Thanks a ton for the help and the suggestions. Will validate and then apply this code.

Regards

Naren

Hi,

Thanks for your observation on the truncation bit. I believe it should not be a problem as an account with currency as USD should never have a value in...

Hi Jeff,

Thanks a ton - this has indeed made my life a lot simpler! A very helpful post.

Thanks

Naren.

Hi Jeff,

Like I mentioned in my reply to David - The reporting tools that we are using are unable to do this. I was just trying to find a workaround...

Hi David,

I agree with you abt the presentation layer doing this formatting. However, not all tools have the capability of dynamically formatting amounts based on a parameter value. I was...

Thanks everyone, I've got a lot of reading material for this weekend and an interesting piece of learning to take away ! Thanks for all the help and inputs!

Thanks everybody, I did figure out that the ANSI settings were different. What I did notice however, was that because of the earlier ANSI settings (most probably the NULLS setting),...