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

Can we collect statistics on table level?

1092


What is the purpose of upsert command?

1261


What are the different methods ot loading a dimension table? A fact table etc?

1083


How do you verify a complicated sql?

1115


What are default access rights in teradata? What explicit right can be given to a user?

1145


What are the different table types that are supported by teradata?

1052


How do you set the session mode parameters in bteq?

1140


What does sleep function does in fast load?

1211


what are the day to day activities of teradata DBA ?

5860


What is the difference between global temporary tables and volatile temporary tables?

1239


What happens in a conflict? How do you handle that?

1103


What are the available primary index types in teradata.

1079


Explain the types of join supports by teradata?

1044


What is the purpose of using case expression in teradata?

1065


What is the purpose of joins in teradata and what are the available join types?

1155