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
- 8590 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
Why do you get spool space errors? How do trouble-shoot them?
What are the updated features of teradata?
how do you manage the production space. what are the proactive methods you can take ?
Explain the most common data types used in teradata?
Explain BYNET.
what is object level locking ? where do appear this type of locking ?
Highlight a few of the advantages that ETL tools have over Teradata.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the functions involved in shared information architecture?
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
Describe the set operators in teradata.
What's the difference between timestamp (0) and timestamp (6)?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the purpose of indexes?
How is MLOAD Teradata Server restarted after execution?
