I'm trying to derive a column using the following expression:
SUBSTRING(RIGHT("000000" + (DT_WSTR,6)TRDAT6,6),1,2)
field data:
71608
with the above expression I was hoping to do this:
07
but all I'm getting is:
7
What the heck am I missing? Thanks in advance!