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

Limit Size of Calculated Field

Status
Not open for further replies.
PGMR1998

PGMR1998

MIS
Apr 10, 2001
29
US
I am creating a file from SQL code,and I am creating a new field in the file using the sum parameter. But the sum field size after I run the code is much larger than I need or want. How can I set its field size?
The resulting field is too large, about size of packed 30. I need only PACKED 10. I also do not need a packed field, but integer.
 
Sort by date Sort by votes
Use the CAST operator.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
That worked! Thanks! Here is what I had to do to change the field from a PACKED 31 into a decimal 10.2 defined field:

CAST( sum(field name) AS decimal(10,2))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
511
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
379
carp
carp
ahadali79
  • Locked
  • Question
Getting a part of string
Replies
2
Views
288
johnherman
johnherman
sqlguy1
  • Locked
  • Question
SQL Server 2008 database size
Replies
1
Views
278
genomon
genomon
adventurous1
  • Locked
  • Question
Parsing Values Out of A URL Field
Replies
4
Views
341
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top