ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Left Outer Join Issue

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    That works great on this field! I appreciate the help!

    Just out of curiosity how would I go about doing the same thing with a numeric value with decimals such as a field defined 7.2. Instead of returning .00 for a zero value I would like it to be blank for zero and if not then an edited field with no leading zeroes. Can this be accomplished?

    Thanks!!!!

    Comment


    • #17
      Just a followup. I found an article by your friend and mine, Ted Holt, about creating an SQL function to handle numeric editing. I did that and all is looking just like I need.

      Thanks for all the help!!!!

      Comment

      Working...
      X