I'm afraid that it does not work.
I found yesterday this script that almost does what i want.
the script is the following:
replace(ltrim(replace(MyField,'0',' ')),' ','0') AS MyField
it transforms 0000001560 into 1560. The correct ammount is 15,6
If the number is 00000078 it displays 78 . the correct should be 0.78.
The correct format should ALWAYS be 0000000xxxxxx --> xxxx,xx.
The last two digits are ALWAYS the decimals.
So how can i make so that the last two digits will always be after the decimal point?