select substr(address,position('n'in address))as first

"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 / nani

Answer Posted / nani

select substr(address,position('n'in address))as first_name
from t1;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do high confidence, low confidence and no confidence mean in explain plan?

1048

What's the difference between timestamp (0) and timestamp (6)?

1196

What can be achieved by using the teradata rdbms?

1038

What is node? How many nodes and amps used in your previous project?

1110

Why are oltp database designs not generally a good idea for a data warehouse?

1056

What are the newly developed features of Teradata?

1031

What is the use of having index on table?

1004

How you will check the version of teradata?

1168

What is meant by a Clique?

1064

What is a node in teradata?

1000

How do you define Teradata?

1038

Explain fallback in teradata?

1065

What are the available primary index types in teradata.

1033

Name the five phases that come under MultiLoad Utility.

988

What are the various indexes in teradata?

1050