troubleshooting Question

Value of 0's not appearing.

Avatar of metalteck
metalteck asked on
Microsoft AccessOracle DatabaseSQL
9 Comments2 Solutions83 ViewsLast Modified:
In my query, I use the following code:

 (SELECT  lpad(trunc(sum(prt.hours)*100),6,'0')  
       FROM prod.prtime prt
       WHERE( prt.tr_date >= add_months(trunc(sysdate, 'mm'),-12)
             AND   prt.tr_date < trunc(sysdate)  )
       and prt.pay_sum_grp in ('REG', 'REGH','OT','ED','OREN')
  --     and prt.employee = 19330
       and emp.company = prt.company (+)
       and emp.employee = prt.employee (+)
       group by prt.employee  ) HOURS_WORKED

For the most part, all the values come across. The issue I'm having is if the value is 0, a blank is being displayed instead of the 0.
Is there anything I can do to ensure that the 0's appear.
I've attached a file with the results I'm getting.
Blanks.docx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros