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

9 Answers
12174 Views
I also Faced
E-Mail Answers

Answer Posted / nani

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to identify ppi columns?

1118

Can we collect statistics on multiple columns?

997

Explain amp in teradata?

1019

Highlight a few of the advantages that ETL tools have over Teradata.

1041

What is the use of virtual processor connectivity in teradata?

958

Did you write stored procedures in teradata?

1072

What are the different table types that are supported by teradata?

968

What is the meaning of Caching in Teradata?

1097

What are the functions of a teradata dba?

1035

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

1040

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 ?

2428

What are the 5 phases in a multiload utility?

994

What is basic teradata query language?

1051

What are teradata utilities?

1049

When tpump is used instead of multiload?

1059