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

How do you create tables? Exact syntax, and create profiles, users in teradata?

970

How to load specific no.of records using bteq, or fastload,or multiload

1690

What are the functions of a Parser?

1023

What are the 5 phases in a multiload utility?

981

What do you mean by parsing?

1055

What is dimensional modeling?

1008

Can you connect multiload from ab initio?

1135

Explain teradata utilities. What is multiload, fast load, tpump?

945

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

931

What are the multiload utility limitations?

1002

What is the purpose of joins in teradata and what are the available join types?

1000

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

924

How to find duplicates in a table?

1130

Describe the set operators in teradata.

951

What is node? How many nodes and amps used in your previous project?

1060