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.