>>>Hi,
>>>
>>>Again, I am trying to make my app to compatible with the numeric system in Europe. I know how to change the decimal point from a period to a comma.
>>>
>>>But how do you change the comma separating thousands to a period? For example, so that 1,000,000.00 becomes 1.000.000,00
>>>
>>>I thought that the Set Separator is designed to help but cannot seem to figure how.
>>>
>>>TIA for any help.
>>
>>You must always make sure that Set Separator and Set Point are different from each other.
>
>I set these as follows:
>set point to "," && comma
>set separator to "." && period
>But I when I do
>? 10000000.00
>The period is changed to comma; this is fine. But I don't see the 1000 separators. What am I doing wrong?
You'll need to use TRANSFORM() with a picture clause to see the commas.
Something like:
? LTRIM(TRANSFORM(10000000.00, "999,999,999,999.99"))