I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jkl

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 / nbk

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

Answers were Sorted based on User's Feedback

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to wr..

Answer / 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

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to wr..

Answer / nitin bansal

You can use TRANSLATE function.

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

Is This Answer Correct ?

1 Yes

1 No

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to wr..

Answer / srav

select case when substr(id,1,3)=';' then ' 'else substr(id,1,3)end from sravya.test4

Is This Answer Correct ?

0 Yes

1 No

Post New Answer