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
- 7743 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
how many modules are there in telecome domain?how to explain the architecture?
Highlight a few of the advantages that ETL tools have over Teradata.
What interface is used to connect to windows based applications?
What are the scenarios in which full table scans occurs?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are the main components of teradata system?
What is primary index and secondary index?
Explain the term 'columns' related to relational database management system?
What are the various etl tools in the market?
Explain the term 'database' related to relational database management system?
What are the primary characteristics of the Teradata.
What is stored procedure in teradata?
What is the purpose of indexes?
Explain and compare pros and cons of start schemas?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
