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
8625 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 happens when a node suffers a downfall?

1066

Difference between stored procedure and macro?

1120

What is meant by a dispatcher?

966

Differentiate database data and data warehouse data?

1063

what are the day to day activities of teradata DBA ?

5765

How do you set the session mode parameters in bteq?

1062

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2107

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1114

What is collect statistics?

953

What are the string manipulation operators and functions associated with teradata?

1040

What are the various indexes in teradata?

986

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

997

What is smp and mpp platforms?

920

What are teradata utilities?

1048

What is the function of parser component in teradata?

1047