"Cismail via SQLMonster.com" <u14416@uwe> wrote in message
news:72b7bccf1011b@uwe...
> Hello,
>
> I have a table that contains values with 16 decimal places in the Weight
> column(table definition below).
> How can I truncate these values to four decimal places???
>
> CREATE TABLE [Detail] (
> [Transaction] [varchar] (10) NULL ,
> [LineNb] [int] NULL ,
> [Weight] [float] NULL
> ) ON [PRIMARY]
>
> example of data in weight column: 4.2999999999999998
>
> I successfully ran the following commands in Query Analyzer but when I
> displayed the table using the SELECT statement nothing changed.
>
> UPDATE Detail SET Weight = CAST(Weight as decimal(15,4))
> UPDATE Detail SET Weight = ROUND(Weight, 4,1)
>
> Thank you for any help.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200705/1
>

"Cismail via SQLMonster.com" wrote:

> Hello,
>
> I have a table that contains values with 16 decimal places in the Weight
> column(table definition below).
> How can I truncate these values to four decimal places???
>
> CREATE TABLE [Detail] (
> [Transaction] [varchar] (10) NULL ,
> [LineNb] [int] NULL ,
> [Weight] [float] NULL
> ) ON [PRIMARY]
>
> example of data in weight column: 4.2999999999999998
>
> I successfully ran the following commands in Query Analyzer but when I
> displayed the table using the SELECT statement nothing changed.
>
> UPDATE Detail SET Weight = CAST(Weight as decimal(15,4))
> UPDATE Detail SET Weight = ROUND(Weight, 4,1)
>
> Thank you for any help.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200705/1
>