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

What are the components used in smp and massively parallel processing (mpp) machines?

1065


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

998


How to Extract data from multiple legacy systems?

1135


What is meant by Teradata Gateway?

1074


Describe the set operators in teradata.

1014


What is the difference between fastload and multiload? Which one is faster?

1237


What are the updated features of teradata?

1052


What is meant by a Parsing Engine?

1198


What is the purpose of upsert command?

1186


What are the advantages of teradata?

1022


why use references rather than pointers in the public api, particularly for arguments which are modified?

1016


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

1108


if collect stats but it show low confidence why?

1704


Define views in teradata with syntax.

1087


What are the main components of teradata system?

1147