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
- 12241 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 some commonly used bteq scripts?
how can we analyze the locks ?
Explain fastload in teradata?
What are different table types used in teradata?
What are the available join types in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
if collect stats but it show low confidence why?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
If a Node is busy what are the steps you can take to avoid ?
Difference between stored procedure and macro?
What are the steps to create a data model?
What is the function of parser component in teradata?
Highlight the need for Performance Tuning.
Explain the term 'database' related to relational database management system?
What are the functions of a Parser?
