Interested to Buy Any Domain ? << Click Here >> for more details...
"pravalli nagireddy" record is there in address column but i
want display only 'nagireddy' from the main string what is
query for that pls tell me
- 9 Answers
- 12124 Views
- I also Faced
- E-Mail Answers
Answer Posted / babu
Hi All,
SELECT SUBSTR('PRAVALLI NAGIREDDY',POSITION('' IN 'PRAVALLI
NAGIREDDY')+1) FROM TABLE_NAME
THIS IS THE CORRECT ANSWER.
IN TERADATA THE FUNCTION INSTR IS NOT WORK.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are differences between teradata and ansi session modes in teradata?
Difference between multiload and tpump?
Explain vproc in teradata?
how can we analyze the locks ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
How can bottlenecks be identified?
Explain teradata utilities. What is multiload, fast load, tpump?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is meant by Teradata Gateway?
What are the different table types that are supported by teradata?
List out all forms of LOCKS that are available in Teradata.
Why are oltp database designs not generally a good idea for a data warehouse?
how many modules are there in telecome domain?how to explain the architecture?
Describe the set operators in teradata.
Mention a few of the ETL tools that come under Teradata.
