Cast(expr as SQL_NUMERIC(10,2)) does not force two decimal places

0

Numbers which would have one or two zeros in the decimal places display either one or no decimal places. What can I do to force display of two decimal places without use SQL_MONEY which also displays a dollar sign.

asked 23 Aug '16, 19:36

jerrykogan's gravatar image

jerrykogan
11●5●5●7
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Tags:

×325
×271

Asked: 23 Aug '16, 19:36

Seen: 1,069 times

Last updated: 23 Aug '16, 19:36

Related questions

select SQL result wrong in ALS12, but the same App result ok with ALS11

How to deal with ADS 12.0 Error 7216 SQL Statement Limit Exceeded

Error ordering records by date. (ALS)

Modify a record blocked with SQL

Bookmark question

SQL Performance - WHERE VS Filter

How search a phone number with CONTAINS

Filter and CONTAINS

How searched the reserved word "and" in CONTAINS

Problem with Adsquery refresh in live cursor

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.