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 / kiran kumar

Sel address,index(address,' ') as r,substr(address,r+1) from tablename;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different table types supported by teradata?

957


how do you manage the production space. what are the proactive methods you can take ?

1940


What are the different functions included in the server software?

1028


What are the steps involved in the process flow of the sql statement through channel attached system?

1100


What are the uses of bynets in multi-node systems?

1026


Explain fallback in teradata?

1050


How to select first n records in teradata?

1100


What is teradata?

1138


Explain some differences between mpp and smp?

1094


Explain Teradata performance tuning and optimization?

1157


What does sleep function does in fast load?

1131


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1072


What is partitioned primary index (ppi)?

1046


Highlight the need for Performance Tuning.

1103


Describe the between keyword in teradata?

1032