Thanks for Both Florian Reischl and Ramesh for your SQL codes.

Thanks for the replies.

I am concerned about "Select" queries. The ASP.Net website uses the database tables for retrieving the data majorly. Any common user should not get affected like slow...

After the advice from Steelymar (Stefan Uzunov from Bulgaria) (forums.asp.net), I changed the datatype to below mentioned it worked. Thanks.

[ItemWeightValue] [decimal](6, 3) NULL,

[MasterCartonWeightValue] [decimal](6, 3) NULL,

[MasterCartonVolumeValue] [decimal](8, 4) NULL,