select case when substr(id,1,3)=';' then ' 'else subst

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

Question Posted / srav

3 Answers
8594 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

Please Help Members By Posting Answers For Below Questions

What is a sparse index?

1022

What are the 5 phases in a multiload utility?

984

What is meant by a dispatcher?

955

What is dimensional modeling?

1013

Can you connect multiload from ab initio?

1135

Why does varchar occupy 2 extra bytes?

1105

What are the frequently used data types in teradata?

1004

What is the difference between fastload and multiload?

1289

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1902

What can be achieved by using the teradata rdbms?

981

Why are oltp database designs not generally a good idea for a data warehouse?

989

Explain teradata vs. Redshift?

956

What is the basic syntax for teradata select statement?

983

What is the difference between teradata and oracle?

955

What is a node in teradata?

935