SELECT dp,dpmc,bc,ygdm,ygxm,;
           sum(IIF(ygjlflm=[01] AND !'内购'$xsdbz ,jxse,0.00)) as jkje,00000.00 as jj1,;
           sum(IIF(ygjlflm=[02] AND !'内购'$xsdbz ,jxse,0.00)) as jjje,00000.00 as jj2,;
           sum(IIF(ygjlflm=[03] AND !'内购'$xsdbz ,jxse,0.00)) as zbje,00000.00 as jj3,00000.00 as jjhj ;
           FROM bmk GROUP BY ygdm ORDER BY dp INTO TABLE xsyj_ygjl
向各位高手求助，在上面语句中生成 的表（xsyj_ygjl.dbf)中，3个数值型字段（jkje 计克金额、jjje 计件金额、zbje 珠宝金额）宽度有16位，想要宽度控制在10位，上述语句要如何修正？才能实现我的需求。 烦请高手赐教，谢谢！

试将0.00改为0000000.00？

SELECT dp,dpmc,bc,ygdm,ygxm,;
    cast( sum(IIF(ygjlflm=[01] AND !'内购'$xsdbz ,jxse,0)) as N(10,2) ) as jkje ;
....

这个问前试过，不灵

我用的是VF8.0 ，没有CAST()这个函数

主要是想节约一点电脑资源

按要求先建空表，然后用insert into ......select......插入数据

感谢！