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
8771 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 are the uses of fact table and dimension table in banking project?

4557

what are the day to day activities of teradata DBA ?

5827

What are the various indexes in teradata? How to use them?

1018

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1043

What are default access rights in teradata?

1126

What is meant by a Virtual Disk?

1137

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1204

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

1955

What is primary index and secondary index?

1028

Which is more efficient group by or distinct to find duplicates?

1090

Explain parsing engine in teradata?

1096

What is the basic syntax for teradata select statement?

1049

What is database exceptions in teradata?

957

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

1035

What are the multiload utility limitations?

1063