sel substr('pravalli nagireddy', index('pravalli nagireddy&

"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

Question Posted / ankal

Answer Posted / ankal

sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is partitioned primary index (ppi)?

997

When tpump is used instead of multiload?

1038

what is sysdba and sysdbc ? which has high priority ?

3759

Explain the term 'columns' related to relational database management system?

985

Highlight the need for Performance Tuning.

1025

Discuss the advantages of using partitioned primary index in a query?

904

Highlight the limitations of TPUMP Utility.

1047

What is difference between user and database in teradata?

1024

What is a dimension table?

981

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1031

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

925

What are the various indexes in teradata? Why are they preferred?

955

Steps to create a data model?

1060

What is meant by a dispatcher?

955

What is teradata and why it is used?

1011