teradata删除字符串中的回车

td删除字符串中的回车
select
case
when position('0A'XC in col1) > 0
then substr(col1,1,position('0A'XC in col1) - 1) || '' || substr(col1,position('0A'XC in col1) + character_length('0A'XC))
else col1
end as col1_replaced
from
(
SEL CCUST_TEL col1 FROM HEMSS.HEMS_M_MATCH_RESULT
WHERE MATCH_RESULT_ROW_ID=17402222
) a
;