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

Explain and compare pros and cons of start schemas?

1148

What is the use of having index on table?

1040

What is bteq utility in teradata?

1024

What is a node in teradata? Explain

1053

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

1053

Why is the case expression used in teradata?

1135

How to select first n records in teradata?

1160

What are differences between teradata and ansi session modes in teradata?

1215

What is meant by a Least Cost Plan?

1106

Syntax for case when statement?

1116

What are normalization, first normal form, second normal form and third normal form?

1102

Which is more efficient group by or distinct to find duplicates?

1129

How many sessions of MAX is PE capable of handling at a particular time?

1135

When tpump is used instead of multiload?

1143

Explain the new features of teradata?

1090