This recursive query helps to remove extra characters present in the data apart from digits.Execute in TERADATA to view the result