473,507 Members | 13,597 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Decimal point in output field

1 New Member
I have many columns of data. They are all using the money datatype. When I
enter a value into a column such as 32.00, it only shows up as 32. When
outputted to an ASP page using a query it also only displays 32. If the
data is 32.33, then the display is 32.33. How do I get it to display 32.00?
Thanks!
Sep 27 '12 #1
2 2235
madankarmukta
308 Contributor
Computed column can be the solution to try over.

Thank you.
Oct 4 '12 #2
ck9663
2,878 Recognized Expert Specialist
If you input 32.33 from your front-end and made sure that it's the same value in the database but it's only showing 32 in your front-end to display, it's an ASP issue, not SQL Server.

Good Luck!!!


~~ CK
Oct 5 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
6747
by: Abe Simpson | last post by:
Hello all, The application I am working on must never output numbers in a floating-point format, that is, something like 2e-002 is a big no-no. At the same time, it must output numbers in a...
1
1512
by: Piero Crincoli | last post by:
I have a xsl file with a test like <xsl:when test="quantity &gt; 100">. It works only if field quantity is expressed with '.' as decimal point, but I need to use the ',' as decimal point. How can I...
3
9696
by: Kim Bundgaard | last post by:
Hi Any suggestion would be fine. I have installed DB2 Connect EE V8.1 (fixpak 4) at two different Windows 2000 Servers, both have the same regional settings. I am connecting to the same DB2...
3
4319
by: Rasool | last post by:
A numeric field is shown differently on the Test and Production env. For example 3.5 is shown as 3,5. Originally we thought this has something to do with Regional Option, however both server have...
6
1667
by: Larry Lard | last post by:
I am trying to apply the following easy-to-state formatting rule to display a number: - If the number is positive or negative, display it in the 'default' way - If the number is zero, the...
18
12151
by: Kuljit | last post by:
I am doing Engineering(B.Tech) in Computer Science. I have a question for which i am struggling to write a C code(program). It struck me when we were being taught about a program which counts the...
2
1904
by: David B | last post by:
I have a app that handles our milk business. The units are recorded as full numbers in the sales table. We have started to handle eggs which are sold by the dozen and sometimes a customer wants...
3
2914
by: Simon Gare | last post by:
Hi all, have a 'money' field in the SQL 2000 table that users enter 200 (for example which represents £2.00) without the decimal point, what I need is to have a command or something that adds...
3
2742
by: Dave Griffiths | last post by:
Hi All Using VB 2005 I am writing a program that will be used on machines which have different locales (English, Norwegian and Swedish) I am restricting textbox input using keypress to just...
5
3586
by: stateemk | last post by:
I'm sure there's an obvious answer for this, but it's not coming to me. I have a make table query that figures a calculated amount for one column. I need to convert this table to a text file with...
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7110
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7030
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7482
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
411
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.