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...

Hi Frnds this que is recently asked at IBM
there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
Can any one help

thanks in advance

Answer Posted / ashutosh gautam

Use DIGITS("aa6588fhfhf") in transform it will return only
digit as 6588.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the points of differences between the database and user in Teradata.

1109


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373


Can you fastexport a field, which is primary key by putting equality on that key?

1178


How to identify ppi columns?

1180


Is multi insert ansi standard?

2207


What is a dimension table?

1064


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

1031


What is TPD?

1374


What are the things to be considered while creating secondary index?

1101


Explain Teradata performance tuning and optimization?

1165


What are the various reporting tools in the market?

1072


How do you set the session mode parameters in bteq?

1106


What is the purpose of joins in teradata?

1190


What do you mean by caching in teradata?

1065


What are the various indexes in teradata?

1050