Using the EARL DECODE to convert scratch status to a YES or NO. Looking for the new field to be pad from the left.
Release : 14.0
Component :
The current DECODE statement is:
DECODE SCRATCH_IND INTO T_SRC
'N' = 'NO '
'Y' = 'YES'
*
Change the 'N' statement to a blank in front of the NO verb:
DECODE SCRATCH_IND INTO T_SRC
'N' = ' NO'
'Y' = 'YES'
Before:
'NO '
After:
' NO'