Solved

Adding Decimals

Posted on 2002-07-18
7
122 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Troubleshoot mediawiki <-> ActiveDirectory authentication 2 120
Website Test Question 6 115
Problem to Eclipse 16 125
wordpress limitations 4 115
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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