How to replace percent (%) character

Question

How to update a row to replace percent character.

UPDATE MPOLITICAS SET NOM_POLITICA =  REPLACE(NOM_POLITICA, '%' , 'PERCENT ');

The row content is NG DEBT 100% - 2014

but should be NG DEBT 100 PERCENT - 2014

Answer 1

Replace function should work fine for this:

UPDATE MPOLITICAS SET NOM_POLITICA =  REPLACE(NOM_POLITICA, '%' , ' PERCENT');

http://sqlfiddle.com/#!4/cc2c4/1