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

How to convert alpha Numeric values to alpha using functions?

Answer Posted / niraj pathak

Using convert function
Sv1=convert (0123456789,col1,"")

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the job parameters?

1266


how to write server Routine coding?

2174


What are the primary usages of datastage tool?

1127


Which commands are used to import and export the datastage jobs?

1455


Can you explain engine tier in information server?

1179


What are iconv and oconv?

1291


Enlist various types of routines in datastage.

1324


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2109


What is a quality stage in datastage tool?

1126


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2953


What is usage analysis in datastage?

1357


in oracle target stage when we use load option and when we use upsert option?

2323


What are the partitioning techniques available in link partitioner?

2320


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1094


How do you reject records in a transformer?

1174