Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Round function. Its very urgent.

Status
Not open for further replies.
rpal

rpal

Programmer
Jun 16, 2003
37
US
Using ROUND function I can get round after decimal but I want to display only 2 decimals after the point.

Ex:
ROUND(2275.4559, 2) Results: 2275.4600
But I want to display only 2275.46


Thanks in advance.
 
Sort by date Sort by votes
Code: 
CONVERT(VARCHAR,CAST(ROUND(2275.4559, 2) AS MONEY),1)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
761
mikrom
mikrom
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
149
briangriffin
briangriffin
bkrampe
  • Locked
  • Question
Round Down to nearest 16th Inch 1
Replies
7
Views
228
bkrampe
bkrampe
Auguy
  • Locked
  • Question
Convert Code to a Function 1
Replies
7
Views
221
Auguy
Auguy
korytnackaruzova
  • Locked
  • Question
Rounddown in SQL and calculating cost
Replies
19
Views
249
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top