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
8656 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

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1192

What is the difference between teradata and basic rdbms?

971

List the logical and conditional operators that are used with teradata along with their meanings?

961

What is spool space? Why do you get spool space errors?

973

What is database exceptions in teradata?

916

What are the uses of bynets in multi-node systems?

986

Explain the advantages of partitioned primary index in a query?

992

Explain the term 'tables' related to relational database management system?

1003

What do you mean by teradata sql assistant?

1019

What is meant by a Channel Driver?

1173

Explain amp in teradata?

1029

How do you define Teradata?

1011

What are the design features involved in teradata?

1005

What can be achieved by using the teradata rdbms?

1004

When tpump is used instead of multiload?

1063