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

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

2031


how can we create rank using datastage?what is the meaning of rank?

8781


What is difference between join, merge and lookup stage?

1088


How you Implemented SCD Type 1 & Type 2 in your project?

4125


What are the job parameters?

1219


What is difference between server jobs & parallel jobs?

1032


Differentiate between datastage and informatica?

1179


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

1150


How do you start developing a datastage project?

1103


Nls stands for what in datastage?

1187


Which warehouse using in your datawarehouse

2182


How do you run datastage job from the command line?

1081


how to sort two columns in single job in datastage.

2896


Differentiate between datastage and datastage tx?

1046


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2857