You can use TRANSLATE function. select translate(Name,'','

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 / nitin bansal

3 Answers
8752 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / nitin bansal

You can use TRANSLATE function.

select translate(Name,'',';') as Name
from tablename;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Highlight the advantages of PPI(Partition Primary Index).

1072

How do you see a ddl for an existing table?

1018

What is the basic syntax for teradata select statement?

1034

What are the various indexes in teradata?

1044

What is the purpose of upsert command?

1169

What tools would you use for that?

1105

What is the difference between teradata and oracle?

1019

Why teradata is used?

997

What is a node in teradata? Explain

1003

What do high confidence, low confidence and no confidence mean in explain plan?

1043

Name the five phases that come under MultiLoad Utility.

982

If RDBMS is halted what will you do ?

2159

What does sleep function does in fast load?

1132

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

1027

What are the frequently used data types in teradata?

1076