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
Answer Posted / nitin bansal
You can use TRANSLATE function.
select translate(Name,'',';') as Name
from tablename;
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the new features of teradata?
What exactly do you know about catching in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What is upsert statement in teradata?
Describe primary index in teradata?
Explain Teradata performance tuning and optimization?
What do you mean by caching in teradata?
Explain amp in teradata?
What are the 5 phases in a multiload utility?
What is logical data model?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the different design perspectives used in teradata?
Difference between star and snowflake schemas?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is the difference between union and union all in teradata?