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
- 8790 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 |
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
how can i answer for question like teradat architecture in interveiw
Can we load a Multi set table using MLOAD?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
What is a level of granularity of a fact table?
What is the diffrence between Multiload & Fastload interms of Performance?
Difference between multiload and tpump?
How do you see a ddl for an existing table?
Why Multiload does not supports USI and supports NUSI?
Where we use PPI in real time??? What is the disadvantages of PPI?
How a Referential integrity is handled in Teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Teradata 
