How do I Zero Fill a Result when I have a REPLACE Function in the Query
Posted on 2012-03-14
So, this is the last part of my Query where It pulls up the Amount the Check is for, removes the Decimal, but I need it to be Zero Filled to the Left up to 10 Digits.
This is the Part of the Query I have so far.
REPLACE (CAST(checknet AS VARCHAR(20)), '.', '')
When the Result comes back, it will come back as follows:
The very last part of that you will see 1833329 That is the check amount of $18,333.29
Because that is only 7 Digits, I need 3 Zero's to fill to the Right.
Thanks again for all of your guy's help!