You can use REPLACE function in order to replace a digit or character in a column.

SELECT REPLACE(col1, '_', ' ') FROM table_1.

This function can also be used to update column's records.

Try this function. Hope it would work.