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
- 3 Answers
- 7745 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
how many modules are there in telecome domain?how to explain the architecture?
What are some commonly used bteq scripts?
What is a node in teradata? Explain
Explain fallback in teradata?
How you will check the version of teradata?
What are teradata utilities?
Why is the case expression used in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What is the maximum number of dml can be coded in a multiload script?
How do you see a ddl for an existing table?
What is spool space?
What is the difference between fastload and multiload? Which one is faster?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain the new features of teradata?
What are the different methods ot loading a dimension table? A fact table etc?
