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
- 12469 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 available join types in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the primary index in teradata?
What is meant by a Clique?
Syntax for case when statement?
Explain parsing engine in teradata?
Can we collect statistics on table level?
Highlight a few of the important components of Teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the various indexes in teradata? How to use them? Why are they preferred?
What happens when a node suffers a downfall?
What is node? How many nodes and amps used in your previous project?
What is stored procedure in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What is teradata? What are some primary characteristics of teradata?
