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
- 8634 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 |
What are the 5 phases in a multiload utility?
How to cast date "2015-03-03-012204-000000" to timestamp
List out all forms of LOCKS that are available in Teradata.
Explain the term 'foreign key' related to relational database management system?
How to find duplicates in a table?
any one answer me how they can analyzing the project using data ware housing?
what are the roles and responsibilities of teradata DBA ?
Explain vproc in teradata?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
in teradata level primary in table level allows duplicates why?
Which is more efficient group by or distinct to find duplicates?
How to copy teradata scripts from ur remote desktop to server machine?
Teradata 
