SQL Server Performance Forum – Threads Archive

bulk insert into float field

Hi all,
Im facing problem as im trying to insert price values in one of the field data typed as float.
Let say it has price 2.60
when i bulk insert in to table it convert into
2.59999999… like that.
Any idea why this is happened. and what is the solution to it.
Please let me know
Thanks in advance.
Sarvagna.

float is approximate value. Use decimal instead
KH

Read about float, decimal, real and numeric datatypes in sql server help file for more information Madhivanan Failing to plan is Planning to fail

]]>