convert not working mysql 8.0 code example

Example: mysql text to decimal

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName