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
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 |
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What do you mean by teradata intellicloud?
What is Join Index in TD and How it works?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
What are the components used in smp and massively parallel processing (mpp) machines?
How do you do backup and recovery in teradata?
why varchar takes 2 extra bytes?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
What is meant by Teradata Gateway?
What are the various reporting tools in the market?
What is collect statistics?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?