Skip to Content
0
Dec 27, 2021 at 08:57 AM

Remove comma

169 Views

Sir, I have this query

SELECT 10*CAST(REPLACE('PKR 5,032.25','PKR','') AS DECIMAL (10,3))  FROM DUMMY;

This shows error message

invalid number: not a valid number string ' 5,032.25' at function __typecast__() (at pos 15)

Please help me to make this query workable.