InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:53:03 GMT20http://www.teradata.com/teradataforum/Topic9273-5-1.aspxyou can make use of a combination of postition, substring, character_length functions and the concatenation operator (||) to accomplish this. The syntax and details are available in the functions and operators manual.Sat, 27 Oct 2007 13:52:22 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic9273-5-1.aspxTeradata does not support this kind of translation.However you can write a udf or use other programming languages to perform this translationFri, 26 Oct 2007 16:52:10 GMTLeoIssachttp://www.teradata.com/teradataforum/Topic9273-5-1.aspxIs there an SQL update statement that can scan through the strings of a column, look for a particular word and replace it with another word? </P><P>The column has sentences in it, and I want to replace just one word while leaving the rest of the sentence intact.Tue, 16 Oct 2007 14:49:43 GMTCapsuleCorpJX