SQL.Add('select huikuanID,yongtu,jinge,shoukuandanwei,kaihuheng,zhanghu,banzu,jingshouren from huikuanmingxi where banzu=:banzu and shoukuandanwei like :huowumingcheng or jinge like :guige as Currency order by riqi ASC');
Parameters.ParamByName('banzu').Value:=banzu;
Parameters.ParamByName('huowumingcheng').Value:='%'+huowumingcheng+'%';
Parameters.ParamByName('guige').Value:='%'+guige+'%';
guige,huowumingcheng是一个广本框的变量
------解决方案--------------------------------------------------------
deiphi里没有money类型,只有Currency货币类型。而且如果你用到小数你会发现,real类型是五舍六入,Currency是四舍五入。这是我在delphi6里面测试的。不知道别的版本是不是这样