Solved

Adding Decimals

Posted on 2002-07-18
7
121 Views
Last Modified: 2013-12-24
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
Comment
Question by:jeffmace
  • 3
  • 2
  • 2
7 Comments
 
LVL 5

Expert Comment

by:CFXPERT
ID: 7162525
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
 
LVL 5

Expert Comment

by:CFXPERT
ID: 7162543
have you tried
decimalFormat(#variableName#)

KWK
0
 

Author Comment

by:jeffmace
ID: 7162580
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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 

Author Comment

by:jeffmace
ID: 7162603
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
 
LVL 17

Accepted Solution

by:
anandkp earned 150 total points
ID: 7164038
hi there,

u can use decimal / float / money

try these & let me know

K'Rgds
Anand
0
 

Author Comment

by:jeffmace
ID: 7180063
I am going to make you rich in this forum
0
 
LVL 17

Expert Comment

by:anandkp
ID: 7180099
Hi Jeff,

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

:)

K'Rgds
Anand
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now