Posted by paulmac106 on 02/23/07 12:58

i got it to work using:

RIGHT('0000'+REPLACE(SUM(tblLines.fldUnits), ' ', '0'), 4)

results in 0015 where SUM(tblLines.fldUnits)=15

• Next in forum: Re: Restore SQL DB with correct logical file names
• Prev in forum: Re: How to run replace on all columns
• Thread view: Re: Format money value as padded string

[Reply to this message]