String Search and Replace.

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

String Search and Replace.

Rate Topic

Display Mode

Topic Options

Author

Message

CapsuleCorpJX

Posted 10/16/2007 2:49:43 PM

Forum Newbie

Group: Forum Members
Last Login: 10/16/2007 2:46:17 PM
Posts: 1, Visits: 2

Is 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?

The column has sentences in it, and I want to replace just one word while leaving the rest of the sentence intact.

Reformat ... the solution to every problem

Post #9273

LeoIssac

Posted 10/26/2007 4:52:10 PM

Supreme Being

Group: Forum Members
Last Login: 5/16/2008 4:54:37 PM
Posts: 166, Visits: 44

Teradata does not support this kind of translation.However you can write a udf or use other programming languages to perform this translation

Leo Issac

"Wants to Learn More!"

Post #9467

joedsilva

Posted 10/27/2007 1:52:22 PM

Supreme Being

Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425, Visits: 398

you 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.

Post #9471

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:45am