﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Teradata Forums / Data Warehousing  / Teradata   / Stripping unknown characters / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>Teradata Forums</description><link>http://www.teradata.com/teradataforum/</link><webMaster>info@teradata.com</webMaster><lastBuildDate>Wed, 03 Dec 2008 20:08:40 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Stripping unknown characters</title><link>http://www.teradata.com/teradataforum/Topic11332-1-1.aspx</link><description>can you give an example of the data format in the table?</description><pubDate>Thu, 01 May 2008 09:47:39 GMT</pubDate><dc:creator>SN</dc:creator></item><item><title>Stripping unknown characters</title><link>http://www.teradata.com/teradataforum/Topic11332-1-1.aspx</link><description>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.</description><pubDate>Wed, 30 Apr 2008 13:36:06 GMT</pubDate><dc:creator>JustMe</dc:creator></item></channel></rss>