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 is teradata?

1235

What do you mean by fastexport in teradata?

1042

What are the things to be considered while creating secondary index?

1140

Why teradata is used?

1050

How is MLOAD Client System restarted after execution?

1201

What is the difference between teradata and oracle?

1064

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

1008

What is teradata and why it is used?

1178

What are the various reporting tools in the market?

1114

What is the command in bteq to check for session settings ?

1231

In BTEQ, how are the session-mode parameters being set?

1189

Which is faster fastload or multiload?

1176

Explain the term 'primary key' related to relational database management system?

1087

List the logical and conditional operators that are used with teradata along with their meanings?

1039

What is logical data model?

1259