"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
- 9 Answers
- 9664 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
sel substr(address,index(address,' ')+1) from db.emp;
will give you the string after the first space in the string.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / chandu
select substr("pravalli nagireddy",10,9) from <table_name>
| Is This Answer Correct ? | 11 Yes | 6 No |
Answer / tdguy
Use substr function to handle character manipulations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran kumar
Sel address,index(address,' ') as r,substr(address,r+1) from tablename;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nani
select substr(address,position('n'in address))as first_name
from t1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ankal
sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / nani
SELECT ARRDESS COLUMN FROM TABLE NAME WHERE ADDRESSCOLUMN='%
NAGIREDDY'
| Is This Answer Correct ? | 0 Yes | 5 No |
Explain teradata utilities?
What are the functions of a teradata dba?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What is the difference between global temporary tables and volatile temporary tables?
What is the purpose of indexes?
If the table does not have duplicates then which utility you can suggest to load the data ?
Explain the parallel data extension in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
What are the design features involved in teradata?
During the Display time, how is the sequence generated by Teradata?
What happens when a node suffers a downfall?
Teradata 
