In TD 14.0, i hope OREPLACE function can be used. SEL OREPLACE(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 / tdguy

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

Answer Posted / tdguy

In TD 14.0, i hope OREPLACE function can be used.
SEL OREPLACE(Name,';',NULL) can be used to remove the ';'
character from the string.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various indexes in teradata? Why are they preferred?

1053

How do you verify a complicated sql?

1113

What is teradata?

1238

Can we collect statistics on multiple columns?

1122

What are the frequently used data types in teradata?

1131

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2220

How you will check the version of teradata?

1221

What is the syntax for case when statement?

1215

What are the different table types supported by teradata?

1019

What are the updated features of teradata?

1089

Explain amp in teradata?

1149

what is sysdba and sysdbc ? which has high priority ?

3883

Explain the advantages of partitioned primary index in a query?

1070

What are tpump utility limitations?

1176

What are the multiload utility limitations?

1112