[firebird-support] Formatting currency

['Check_Mail' check_m...@satron.de [firebird-support]]

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