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
8930 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 meant by a dispatcher?

1062

What is the meaning of Caching in Teradata?

1185

What is bteq script in teradata?

1211

In Teradata, how do we Generate Sequence?

1088

Highlight a few of the advantages that ETL tools have over Teradata.

1136

What is meant by a Clique?

1114

What are the things to be considered while creating secondary index?

1140

What do you mean by ttu in teradata?

1082

What are the various etl tools in the market?

1121

Explain the parallel data extension in teradata?

1151

What is the purpose of using case expression in teradata?

1064

Explain teradata utilities?

1093

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2220

What are different table types used in teradata?

1093

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1210