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
- 8780 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nitin bansal
You can use TRANSLATE function.
select translate(Name,'',';') as Name
from tablename;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srav
select case when substr(id,1,3)=';' then ' 'else substr(id,1,3)end from sravya.test4
| Is This Answer Correct ? | 0 Yes | 1 No |
How many sessions of MAX is PE capable of handling at a particular time?
What are the different functions performed in development phase?
What is called partitioned primary index (ppi)?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
List out some of the primary characteristics of teradata.
What is teradata?
Explain the advantages of partitioned primary index in a query?
What is basic teradata query language?
What is meant by a node?
Differentiate primary key and partition key?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
What is the process to restart the multiload if it fails?
Teradata 
