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
- 12746 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 the updated features of teradata?
Explain the types of join supports by teradata?
Can we collect statistics on multiple columns?
How does hashing happens in teradata?
What do you mean by tpt in teradata?
What is the difference between fastload and multiload? Which one is faster?
What tools would you use for that?
What is the purpose of joins in teradata?
What is the maximum number of dml can be coded in a multiload script?
List out all forms of LOCKS that are available in Teradata.
What is bteq utility in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Which is faster fastload or multiload?
how many modules are there in telecome domain?how to explain the architecture?
What are different table types used in teradata?
