Interested to Buy Any Domain ? << Click Here >> for more details...
"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
- 12165 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 |
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are normalization, first normal form, second normal form and third normal form?
What is the diffrence between Multiload & Fastload interms of Performance?
What is meant by a dispatcher?
in teradata level primary in table level allows duplicates why?
Difference between multiload and tpump?
if a error occured in FASTLOAD is the fastload job stops?
Highlight a few of the important components of Teradata?
What are the steps to create a data model?
why varchar takes 2 extra bytes?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What is called partitioned primary index (ppi)?
Teradata 
