I am converting a number from varchar to decimal. This number already has the boxes after the comma, and when converted it adds two more zeros.
Example: 12,345.67 --- > 1234567,00
The code I am using is this: CAST (REPLACE (REPLACE (ZMI058.Montante, ',', ''), '.', '') AS decimal (18,2) AS Amount
How do I play the numbers I already have for the decimal places?