SQL Server 2000 Displaying Decimals

[arrian]

I'm not entierly sure if this can be done... But I've got a few fields that I *ALWAYS* want to display 2 decimals (ie 3.40, 2.35, 1.00) I'm not entierly sure how I can do this. Anyone know?

 

[SQLDenis]

2 examples
select convert(decimal(10,2),55555555)

select convert(decimal(10,2),555.55555)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

Do you want to change the original data?

You could do this:

ALTER TABLE tablename
ALTER COLUMN columname DECIMAL(x,2)

The x has to be replaced with the maximum length of the data, including the decimal value. (1234.56 would be DECIMAL(6,2))

If you can't or don't want to change the columns, then SQLDenis' suggestion is the way to go.

-SQLBill

Posting advice: FAQ481-4875

 

[arrian]

If I change the column to decimal, though, will that ALLWAYS show 2 decimal points? I need it to show 1.10 and 1.00 as well...