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

What is the difference between teradata and basic rdbms?

1072

How many tables can you join in v2r5?

1116

When tpump is used instead of multiload?

1143

Explain the new features of teradata?

1090

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

1103

What do you mean by teradata intellicloud?

1075

In Teradata, what is the significance of UPSERT command?

1314

What are the components used in smp and massively parallel processing (mpp) machines?

1093

What is oltp?

1013

Syntax for case when statement?

1115

What is meant by a Parsing Engine?

1234

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1143

What are the steps involved in the process flow of the sql statement through channel attached system?

1159

What is a sparse index?

1119

What is the difference between global temporary tables and volatile temporary tables?

1237