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 add zero "0" before record in a field?

Answer Posted / santhu

Ranjan is right but when we want add 4 zeros("0")then By Using String Function we can do that

String("o",1):Column name
Here 1 is how many zeros we want

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do y read Sequential file from job control?

15797


What all are the different way to run a job?

1027


What are orabulk and bcp stages?

1067


Can you define merge?

1062


What is the difference between hashfile and sequential file?

1185


what is the use of materialized view?

1486


How a server job can be converted to a parallel job?

1041


If you want to use a same piece of code in different jobs, how will you achieve this?

1224


How many areas for files does datastage have?

1083


Define meta stage?

1142


how to write server Routine coding?

2061


Explain the situation where you have applied SCD in your project?

1972


What is the project in datastage?

1046


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2444


why do u need the IOS upgradation in a FC switch

2223