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
- 7446 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 |
Explain vproc in teradata?
Can we collect statistics on table level?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
Highlight a few of the important components of Teradata?
Can you connect multiload from ab initio?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is a level of granularity of a fact table?
can i call router is a passive transformation
When tpump is used instead of multiload?
Explain the term 'database' related to relational database management system?
What is oltp?
Teradata 
