Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / ankal

sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of using case expression in teradata?

1018


What is a sparse index?

1092


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

3626


Describe the set operators in teradata.

1009


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

1059


What is meant by a Virtual Disk?

1140


What is meant by a Clique?

1066


Highlight the need for Performance Tuning.

1113


How you will check the version of teradata?

1170


What is the purpose of upsert command?

1180


How do you do backup and recovery in teradata?

1026


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2482


Explain fastload in teradata?

1113


Highlight the advantages of PPI(Partition Primary Index).

1079


What are the available join types in teradata?

1073