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

Highlight the points of differences between the database and user in Teradata.

1157

What is smp and mpp platforms?

1031

how many modules are there in telecome domain?how to explain the architecture?

2062

What is inner join and outer join?

1166

How does hashing happens in teradata?

1144

Explain PDE.

1127

What are the enhanced features in teradata v2r5 and v2r6?

1182

What are the different table types supported by teradata?

1016

How do you set the session mode parameters in bteq?

1138

Explain teradata vs. Redshift?

1076

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

1140

What are the commands to make a new table, change a table and remove a table in teradata?

1181

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1199

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

1250

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1148