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
- 7742 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by caching in teradata?
What is the difference between union and union all in teradata?
What is the use of stored procedures in teradata?
what are the day to day activities of teradata DBA ?
What is meant by a node?
What are the different functions included in the server software?
What are the various etl tools in the market?
What are default access rights in teradata? What explicit right can be given to a user?
What is meant by a Channel Driver?
Explain how spool space is used.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is meant by a dispatcher?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Syntax for case when statement?
