So, what is the query that you are trying to run?

you could try

select replace (name,'') from table;