SELECT TAXNR,replace(TAXNR,’ ‘,”),* FROM LG_013_CLCARD

 

UPDATE LG_013_CLCARD SET TAXNR=replace(TAXNR,’ ‘,”)