oracle : replace(replace(GXSCODE,CHR(13),''),CHR(10),'') sql : replace(gxscode , CHAR(13)+CHAR(10),'')