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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numbers

Status
Not open for further replies.
NoKeS

NoKeS

Programmer
Sep 27, 2001
21
PT
How do I do to turn this:

A dívida do Cliente é: 18450 $ESC
A dívida do Cliente é: 83.86363636363 $USD
A dívida do Cliente é: 603.67110558518 $FFR

Into:

A dívida do Cliente é: 18450 $ESC
A dívida do Cliente é: 83.86 $USD
A dívida do Cliente é: 603.67 $FFR
 
Sort by date Sort by votes
Hi not sure if this is what you mean but there is a function in Transact SQL called ROUND
ROUND(variable, number to round to)
e.g ROUND(83.86363636363, 2)
will give you 83.63;-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kermit01de
  • Locked
  • Question
gaps between item numbers
Replies
5
Views
329
bborissov
bborissov
grnzbra
  • Locked
  • Question
Pivot Table Without Numbers 1
Replies
12
Views
437
SkipVought
S
microsGuy16
  • Locked
  • Question
Get "available" numbers
Replies
6
Views
267
gbaughma
gbaughma
wbodger
  • Locked
  • Question
Find consecutive numbers 3 or more within a set
Replies
3
Views
211
gmmastros
gmmastros
bmacbmac
  • Locked
  • Question
Varchar column containing numeric and alphanumeric - trying to select where values between numbers 4
Replies
11
Views
392
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top