Sel address,index(address,' ') as r,substr(address,r+1) from tabl

"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 / kiran kumar

Answer Posted / kiran kumar

Sel address,index(address,' ') as r,substr(address,r+1) from tablename;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the various indexes in teradata? How to use them?

1018

How do you see a ddl for an existing table?

1018

What do you mean by teradata sql assistant?

1063

Differentiate primary key and partition key?

983

What type of indexing mechanism do we need to use for a typical data warehouse?

1166

How to identify ppi columns?

1180

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2165

What are the available primary index types?

1222

List out all forms of LOCKS that are available in Teradata.

969

How to Extract data from multiple legacy systems?

1122

What are the different softwares used with their functions in teradata?

1015

What is primary index and secondary index?

1028

Explain teradata vs. Redshift?

1023

What is basic teradata query language?

1117

What is the purpose of upsert command?

1177