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!

Setting precision of calculated fields

Status
Not open for further replies.
snello

snello

Programmer
Mar 10, 2001
1
US
My SQL statement creates a recordset that includes an aggregate function on one attribute, how can I set the precision of the result?

The statement is included within an ASP page using VBScript as the server side language.

Any Help???
 
Sort by date Sort by votes
If you have a field that's overflowing to to many DP then I'd use round

select round(1.111111,2) from dual

returns

1.11

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
232
2009luca
2009luca
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
193
carp
carp
ahadali79
  • Locked
  • Question
Getting a part of string
Replies
2
Views
175
johnherman
johnherman
PGMR1998
  • Locked
  • Question
Limit Size of Calculated Field
Replies
2
Views
89
PGMR1998
PGMR1998
adventurous1
  • Locked
  • Question
Parsing Values Out of A URL Field
Replies
4
Views
191
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top