Re: changing data type or converting
From: Andrew John (aj_at_DELETEmistrose.com)
Date: 04/13/04
- Next message: Michael, Cheng [MST]: "RE: using xp_cmdshell to run a droplet"
- Previous message: Billy Yao [MSFT]: "Re: ALTER TABLE <Table> DISABLE TRIGGER ALL on published tables"
- In reply to: enrico martinelli: "changing data type or converting"
- Next in thread: Bharath NS: "RE: changing data type or converting"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 13:44:08 +1000
Enrico,
This is normally more a client side display thing, than a server side task.
SQL does have the round() function:
Select round(MyColumn,2) from MyTable
Regards
AJ
"enrico martinelli" <anonymous@discussions.microsoft.com> wrote in message
news:1713a01c420f7$cf225080$a001280a@phx.gbl...
> Hello there!
>
> I have a column in a table with data type float, which
> has data such as 0.00, -3.9765600000, 56764.7664, etc...
>
> I just want this column to show positive or negative or
> zero with 2 decimal to the right.
>
> Any ideas are highly appreciated.
>
> thanks!
- Next message: Michael, Cheng [MST]: "RE: using xp_cmdshell to run a droplet"
- Previous message: Billy Yao [MSFT]: "Re: ALTER TABLE <Table> DISABLE TRIGGER ALL on published tables"
- In reply to: enrico martinelli: "changing data type or converting"
- Next in thread: Bharath NS: "RE: changing data type or converting"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
