This is driving me nuts!!

R

RobertM

I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.
 
M

Marshall Barton

RobertM said:
I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.
Click to expand...


It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.
 
D

Dennis

I have just tried it and it pastes OK. My number was set to Double with 6
decimal places. What number type is yours ?
 
P

peregenem

Marshall said:
It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.
Click to expand...

It sound like the data is DECMIAL(n, 6) to me e.g.

SELECT TYPENAME(108.577645)

returns 'Decimal'.

Exmaple:

ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6)
 
Top