Subject Formatting currency
Author Check_Mail

Hello,

 

how can I format a value to Euro with decimal pointers like 123.456,44 Euro ?

 

If I do this: select cast(1112223.444 as decimal(18,2)) from rdb$database – I get 1.112.223,44, but if I select this and store it in a varchar-variable, I get 1112223.44, with the point, not comma.

 

Thank you.

 

Regards

 

Olaf