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 scenarios in which full table scans occurs?

939

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017

what are the uses of fact table and dimension table in banking project?

4491

What are the advantages of teradata?

956

In Teradata, what is the significance of UPSERT command?

1130

What is spool space?

1074

Explain BYNET.

947

What is the opening step in basic teradata query script?

977

Explain parsing engine in teradata?

1024

What is meant by Teradata Gateway?

1003

Did you write stored procedures in teradata?

1058

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

1031

Difference between star and snowflake schemas?

1049

What is the use of stored procedures in teradata?

942