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 '

[Back to original message]