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
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
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is difference between user and database in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the various indexes in teradata?
Highlight all the modes that are present under Confidence Level.
Can you fastexport a field, which is primary key by putting equality on that key?
Different phases of multiload?
Explain the advantages of partitioned primary index in a query?
Explain and compare pros and cons of start schemas?
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 are types of partition primary index (ppi) in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Why managing the data is important?
Differentiate primary key and partition key?
any one answer me how they can analyzing the project using data ware housing?