I am trying to change numeric values to a string.
For example I would like to change 148.32 to "0014832"
or 50.00 to "00005000"
It seems like I need to use a combination of STR() and
PADL() but I cannot seem to get PadL to work.
I tried this:
but it does not seem to work.