• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

Adding Decimals

I need to add columns.... I already know how to that that part. The problem i run into is when i need to do 1/4 or 1/2.    Most of the time I am just putting in 1,2 or 3 but every now and then i need to do .25 or .5, etc.. these come back as '0'.... How can retain that number so that it can ad up to  23.25 or whatever.

I am using SQL Server 2000 in cases it has to do with a database modification.

Thanks
0
jeffmace
Asked:
jeffmace
  • 3
  • 2
  • 2
1 Solution
 
CFXPERTCommented:
You have 9 questions that are still open.  You may want to close some of those before asking more.  Some experts may not want to help you if you're not accepting comments from them as answers.

KWK
0
 
CFXPERTCommented:
have you tried
decimalFormat(#variableName#)

KWK
0
 
jeffmaceAuthor Commented:
that will work for the number, but I think its a sql database problem... i am not sure what to set the field as so that it will accept decimals... right now i have it set to numeric
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
jeffmaceAuthor Commented:
I figured out the problem myself.. You should use 'Float' in the database as a datatype... if anyone thinks this is wrong, please feel free to correct me.
0
 
anandkpCommented:
hi there,

u can use decimal / float / money

try these & let me know

K'Rgds
Anand
0
 
jeffmaceAuthor Commented:
I am going to make you rich in this forum
0
 
anandkpCommented:
Hi Jeff,

what can i say - but - THANX A LOT !!!

:)

K'Rgds
Anand
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now