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 / gvk

select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from <tablename>

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between user and database in teradata?

1071


How can you track login parameters of users in teradata?

1196


What are the enhanced features in teradata v2r5 and v2r6?

1138


What is stored procedure in teradata?

1031


What is the primary index in teradata?

1203


What is the difference between teradata and basic rdbms?

1026


How do you create tables? Exact syntax, and create profiles, users in teradata?

1036


Explain the most common data types used in teradata?

1075


Which is faster fastload or multiload?

1117


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113


What are some primary characteristics of teradata?

1001


What are the functions of a Parser?

1113


What are types of partition primary index (ppi) in teradata?

1055


Why teradata is used?

1008


What is teradata? What are some primary characteristics of teradata?

974