Interested to Buy Any Domain ? << Click Here >> for more details...
I Have Name field in a Table
Name
-------------
abcde;fgh;ijk;
abc;def;jklm;no
I want to write a sql to display name field data with out
';'.so i want to replace ; with '' how will write in
Teradata
- 3 Answers
- 8768 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In TD 14.0, i hope OREPLACE function can be used.
SEL OREPLACE(Name,';',NULL) can be used to remove the ';'
character from the string.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of joins in teradata and what are the available join types?
Highlight a few of the advantages that ETL tools have over Teradata.
What do you mean by parsing?
How can bottlenecks be identified?
What is collect statistics?
What do you mean by teradata intelliflex?
Highlight the limitations of TPUMP Utility.
What tools would you use for that?
What are the newly developed features of Teradata?
Explain PDE.
How do you determine the number of sessions?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Comment whether bottleneck is an error or not.
Highlight the advantages of PPI(Partition Primary Index).
Which is more efficient group by or distinct to find duplicates?
