> Date: Wed, 3 Jan 2001 11:11:36 -0700
> From: Michael Davis <[EMAIL PROTECTED]>
!> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
!> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
!> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
!> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: [S
[ mail lists trimmed to something a tad more reasonable ]
Michael Davis <[EMAIL PROTECTED]> writes:
> From within Access, I can't update any table with a numeric data type
> because of the "select * from tst where amount = 1.1;" failure.
Yeah. The problem here is the conflict between interpret
Hi Michael,
>create table tst (id int, amount numeric(9,2));
>insert into tst values (1, 1.10);
>insert into tst values (2, 1.00);
>insert into tst values (2, 2.00);
>select * from tst where amount = 1; -- works
>select * from tst where amount = 1.1
