Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Adding Decimals

Posted on 2002-07-18
7
Medium Priority
?
128 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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 600 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

670 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