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 / 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 are the design features involved in teradata?
What is smp and mpp platforms?
How to identify ppi columns?
What is meant by a Parsing Engine?
What is the difference between teradata and oracle?
Explain and compare pros and cons of snow flake schemas?
what are the uses of fact table and dimension table in banking project?
What do you mean by teradata intellicloud?
What happens when a node suffers a downfall?
What are some primary characteristics of teradata?
What is meant by a Least Cost Plan?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What do you mean by fastexport in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What is bteq script in teradata?