How To Get The Value With Leading Zeros?

1.	How To Get The Value With Leading Zeros?
Answer» SELECT POLICY_NUMBER, DIGITS (BASE_PREM_TOT) FROM DB2K.CGIST.TW4T0 If the VALUE of BASE_PREM_TOT is 472.00 then it will be SELECTED as LIKE this 00000047200 SELECT POLICY_NUMBER, DIGITS (BASE_PREM_TOT) FROM DB2K.CGIST.TW4T0 If the value of BASE_PREM_TOT is 472.00 then it will be selected as like this 00000047200

Answer»

SELECT POLICY_NUMBER, DIGITS (BASE_PREM_TOT)
FROM DB2K.CGIST.TW4T0
If the VALUE of BASE_PREM_TOT is 472.00 then it will be SELECTED as LIKE this 00000047200

SELECT POLICY_NUMBER, DIGITS (BASE_PREM_TOT)
FROM DB2K.CGIST.TW4T0
If the value of BASE_PREM_TOT is 472.00 then it will be selected as like this 00000047200

Discussion

No Comment Found

Related InterviewSolutions

What Is Tsq And Tdq?
How To Find N Th Max Or Min
How To Get The Max Count When Group By Some Other Field
How To Subtract The Years, Months And Days Separately From Date
How To Eliminate Duplicate Records Except One
How To Execute The Sql Through Jcl Using Utility
How To Count Occurrence Of Letter In A String?
How To Delete Duplicated Based On Certain Column Retaining One
Correlated Sub Query?
How To Get The Value With Leading Zeros?

How To Get The Value With Leading Zeros?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment