Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advanced String Parsing?

Status
Not open for further replies.

CapsuleCorpJX

IS-IT--Management
Jun 23, 2004
70
US
Does Teradata SQL support string parsing like a replace function?

for example:
select replace(<old_char>,<new_char>,<string_var>) from testdb.testtable;
 
Only on V2R5.1 using a UDF.
You'll find REPLACE in the download section at teradata.com:
In the "Oracle UDFs" library

Dieter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top