Value Truncates When Using Float Datatype

[Aads]

Hi all,

Below is my query which truncates the value of the float variable. I have no clue why it truncates. Can anyone help me out?


Declare @myValue Float
set @myValue = 0.0045645667657 7567
Print @myValue


Thanks,
Aads

[ck9663]

Can you use decimal instead of float?

Declare @myValue decimal(20,20)
set @myValue = 0.00456456676577567
Print @myValue

-- CK

[Aads]

Yeah I can use decimal instead of float. Thanks a lot! It works!


Regards,
Aads