asked on
How do I Zero Fill a Result when I have a REPLACE Function in the Query
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:
00012345678900100000299742
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!
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:
00012345678900100000299742
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!
Microsoft SQL Server 2008Microsoft SQL Server 2005
Last Comment
Rmumpower00
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You are the man! Thank you