Hi All, SELECT SUBSTR('PRAVALLI NAGIREDDY',POSITION('&#

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

9 Answers
12449 Views
I also Faced
E-Mail Answers

Answer Posted / babu

Hi All,

SELECT SUBSTR('PRAVALLI NAGIREDDY',POSITION('' IN 'PRAVALLI
NAGIREDDY')+1) FROM TABLE_NAME

THIS IS THE CORRECT ANSWER.

IN TERADATA THE FUNCTION INSTR IS NOT WORK.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How will you solve the problem that occurs during update?

1053

What are different table types used in teradata?

1041

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048

What do you mean by parsing?

1110

Define views in teradata with syntax.

1077

Explain fallback in teradata?

1058

What is the use of teradata system software?

1036

What is a clique?

1093

What are default access rights in teradata? What explicit right can be given to a user?

1112

What are the functions of a Parser?

1113

Difference between star and snowflake schemas?

1150

What are the multiload utility limitations?

1054

What are differences between teradata and ansi session modes in teradata?

1175

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

1047

What is a dimension table?

1063