Posted by paulmac106 on 02/22/07 20:46

thanks that worked great.

any idea why this doesn't work:

REPLACE(CONVERT(CHAR(4),SUM(tblLines.fldUnits)),' ','0')

it just won't seem to put the zero in....very strange

i get this for 15: '15 '

• Next in forum: How to run replace on all columns
• Prev in forum: Re: Format money value as padded string
• Thread view: Re: Format money value as padded string

[Reply to this message]