Query For Removing the Special Character of "POST Database"

Query For Removing the Special Character of "POST Database"


update    dcl.nomineeinfo set nomaddr = replace(replace(replace(replace(replace(nomaddr, char(45), ''), char(58), ''), char(38), ''), char(61), char(32)), char(59), char(32))
update    dcl.nomineeinfo set nomaddr = replace(replace(replace(replace(replace(nomaddr, char(45), ''), char(42), ''), char(38), ''), char(61), ''), char(59), char(32))
update    dcl.mindxreg set name1 = replace(name1, char(39), char(32))
update    dcl.nsc_binder set name1 = replace(name1, char(39), char(32))

update    dcl.rdindex set name1 = replace(name1, char(39), char(32))
update    dcl.indexreg set name1 = replace(name1, char(38), char(32))
update    dcl.indexreg set name1 = replace(name1, char(39), char(32))
update    dcl.indexreg set name1 = replace(name1, char(58), char(32))
update    dcl.indexreg set name1 = replace(name1, char(59), '')
update    dcl.kvp_addrbook set addr1 = replace(addr1, char(34), char(32))
update    dcl.kvp_addrbook set addr1 = replace(addr1, char(58), '')
update dcl.indexreg set addr1=replace(addr1,'/',' ')
update dcl.rdindex set addr1=replace(addr1,'/',' ')
update dcl.nsc_binder set name1=replace(name1,'/',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'/',' ')
update dcl.kvp_binder set name1=replace(name1,'/',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'/',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'/',' ')
update dcl.mindxreg set name1=replace(name1,'/',' ')

update dcl.indexreg set addr1=replace(addr1,'\',' ')
update dcl.rdindex set addr1=replace(addr1,'\',' ')
update dcl.nsc_binder set name1=replace(name1,'\',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'\',' ')
update dcl.kvp_binder set name1=replace(name1,'\',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'\',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'\',' ')
update dcl.mindxreg set name1=replace(name1,'\',' ')



update dcl.indexreg set addr1=replace(addr1,'(',' ')
update dcl.rdindex set addr1=replace(addr1,'(',' ')
update dcl.nsc_binder set name1=replace(name1,'(',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'(',' ')
update dcl.kvp_binder set name1=replace(name1,'(',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'(',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'(',' ')
update dcl.mindxreg set name1=replace(name1,'(',' ')



update dcl.indexreg set addr1=replace(addr1,')',' ')
update dcl.rdindex set addr1=replace(addr1,')',' ')
update dcl.nsc_binder set name1=replace(name1,')',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,')',' ')
update dcl.kvp_binder set name1=replace(name1,')',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,')',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,')',' ')
update dcl.mindxreg set name1=replace(name1,')',' ')


update dcl.indexreg set addr1=replace(addr1,'&',' ')
update dcl.rdindex set addr1=replace(addr1,'&',' ')
update dcl.nsc_binder set name1=replace(name1,'&',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'&',' ')
update dcl.kvp_binder set name1=replace(name1,'&',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'&',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'&',' ')
update dcl.mindxreg set name1=replace(name1,'&',' ')


update dcl.indexreg set addr1=replace(addr1,',',' ')
update dcl.rdindex set addr1=replace(addr1,',',' ')
update dcl.nsc_binder set name1=replace(name1,',',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,',',' ')
update dcl.kvp_binder set name1=replace(name1,',',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,',',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,',',' ')
update dcl.mindxreg set name1=replace(name1,',',' ')




update dcl.indexreg set addr1=replace(addr1,'*',' ')
update dcl.rdindex set addr1=replace(addr1,'*',' ')
update dcl.nsc_binder set name1=replace(name1,'*',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'*',' ')
update dcl.kvp_binder set name1=replace(name1,'*',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'*',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'*',' ')
update dcl.mindxreg set name1=replace(name1,'*',' ')




update dcl.indexreg set addr1=replace(addr1,';',' ')
update dcl.rdindex set addr1=replace(addr1,';',' ')
update dcl.nsc_binder set name1=replace(name1,';',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,';',' ')
update dcl.kvp_binder set name1=replace(name1,';',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,';',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,';',' ')
update dcl.mindxreg set name1=replace(name1,';',' ')



update dcl.indexreg set addr1=replace(addr1,':',' ')
update dcl.rdindex set addr1=replace(addr1,':',' ')
update dcl.nsc_binder set name1=replace(name1,':',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,':',' ')
update dcl.kvp_binder set name1=replace(name1,':',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,':',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,':',' ')
update dcl.mindxreg set name1=replace(name1,':',' ')



update dcl.indexreg set addr1=replace(addr1,'=',' ')
update dcl.rdindex set addr1=replace(addr1,'=',' ')
update dcl.nsc_binder set name1=replace(name1,'=',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'=',' ')
update dcl.kvp_binder set name1=replace(name1,'=',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'=',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'=',' ')
update dcl.mindxreg set name1=replace(name1,'=',' ')


update dcl.indexreg set addr1=replace(addr1,'"',' ')
update dcl.rdindex set addr1=replace(addr1,'"',' ')
update dcl.nsc_binder set name1=replace(name1,'"',' ')
update dcl.nsc_addrbook set addr1=replace(addr1,'"',' ')
update dcl.kvp_binder set name1=replace(name1,'"',' ')
update dcl.kvp_addrbook set addr1=replace(addr1,'"',' ')
update dcl.nomineeinfo set nomaddr=replace(nomaddr,'"',' ')
update dcl.mindxreg set name1=replace(name1,'"',' ')