Hi all, hope in your help.

I need update the table tbl_a with this query:
Code:
UPDATE tbl_a a
JOIN tbl_ca ca ON a.XYZ = ca.XYZ
JOIN tbl_cb cb ON a.Amb = cb.Amb
SET a.Amb = ca.Amb,
 a.Dur = cb.Dur,
 a.C_Int = ROUND(((a.A2 * a.Dur) / 60), 2);
When adding this line in update query:
Code:
 a.C_Int = ROUND(((a.A2 * a.Dur) / 60), 2);
I have this error:
Code:
[Err] 1292 - Truncated incorrect DOUBLE value: '111,00'
I tried this query for convert string (varchar) to decimal:
Code:
SELECT
	CAST('1.505,00' AS DECIMAL(10, 2)) AS result
FROM
	tbl_a ;
But the result is: 1,51 that is different from 1.505,00...

these are the fields of the table but I can not edit directly in the table:
Code:
Dur	decimal	10,2
C_Int	varchar, 255
A2	varchar, 255
Can you help me?
thank you.