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
8769 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 meant by a Highest Cost Plan?

1063

If a Node is busy what are the steps you can take to avoid ?

2416

What do you mean by tpt in teradata?

1021

What are the functions involved in shared information architecture?

1073

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

1003

How can you track login parameters of users in teradata?

1198

What do you mean by teradata intelliflex?

1110

What is node? How many nodes and amps used in your previous project?

1110

What are the functions performed by bynet?

1043

How is MLOAD Teradata Server restarted after execution?

1267

What do you mean by fastexport in teradata?

1006

What type of indexing mechanism do we need to use for a typical data warehouse?

1168

What are the available join types in teradata?

1072

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

1243

Highlight the advantages of PPI(Partition Primary Index).

1078