这个问题困扰我好久了.......

[appleWanter]

select fieldFloat from Tablea

fieldFloat
----
15.460000000000001

但我只想要15.460

用select round(fieldFloat,3) from Tablea 不能解决,怎么办?

[饮水需思源]

在VB代码中：format(rs!fieldfloat,"###0.000")

[熊孩子开学喽]

使用FORMAT函数,示例：
DIM A AS DOUBLE
A=12.12300232002
MSGBOX FORMAT(A,"0.000")

[appleWanter]

能不能在sql中实现?

[appleWanter]

cast(field as numeric(10,3))

[cheng0733]

select cast(fieldfloat as number(8,3)) from tablea