Stripping unknown characters

UDA
Enthusiast

Stripping unknown characters

How can I, in a select statement, strip "garbage" characters from a column in my result set? For example, we have a table that was loaded by another application, and some of the values contain what looks like a carriage return character.
1 REPLY
SN
Enthusiast

Re: Stripping unknown characters

can you give an example of the data format in the table?