select substr("pravalli nagireddy",10,9) from <table

"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 / chandu

Answer Posted / chandu

select substr("pravalli nagireddy",10,9) from <table_name>

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the use of fallback?

1033

Explain the teradata primary index mechanics in detail with a diagram.

1034

What is bteq utility in teradata?

1023

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1154

What is the primary index in teradata?

1277

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

1177

What is basic teradata query language?

1158

What are types of partition primary index (ppi) in teradata?

1100

Explain parsing engine in teradata?

1136

Explain fallback in teradata?

1096

What are the joins in teradata?

1068

How many types of joins are there in teradata?

1019

In Teradata, how do we Generate Sequence?

1084

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3686

Difference between star and snowflake schemas?

1234