I have the following sql:

select upper(ac_activity_descr)
,ws_score
,ws_impact
,ws_target
,round((ws_score*(ws_impact/ws_target)),2)
, ws_activity_no
from web_scorecard, activity

where ws_quarter='q1 2003' --variable
and ws_engineer='keyefran' --variable
and activity.ac_activity_no = ws_activity_no

order by ws_activity_no

The output is:


CASES PER WEEK 2.34 60.00 3.00 46.80000000000 1
% CLOSED 80.77 50.00 50.00 80.77000000000 2
% CLOSED 24 42.86 15.00 50.00 12.86000000000 3
% REOPEN .00 -10.00 7.00 .00000000000 4
AVE DAYS STATUS 2.10 -40.00 2.00 -42.00000000000 5
AVE DAYS RESOLVE 4.17 -10.00 7.00 -5.96000000000 6
IA 80.00 70.00 80.00 70.00000000000 7
GAP 2.00 -35.00 2.00 -35.00000000000 8

In column 5, you can see there are many trailing zeros. I want to only view up to 2 decimal places. if i use the round function it rounds to 2 decimal places but does not remove the other trailing zeros - how can i do this?

Thanks in advance, Luke


Yeeeeeha cowboy!

__________________
Yeeeeeha cowboy!

First check the data type for that column.

you can use cast to change the field type

SELECT CAST(ws_score AS int)

Or if you want to keep atleast 2 decimal places and remove off the others, you can use

select cast(150.790000000 as decimal(10,2))

Cheers!

-Vijay G

Thanks for the reply, sorry about the late 'Thankyou' but its been Easter!

I will give this a go and see if it works.

Many thanks, Luke

Yeeeeeha cowboy!

http://www.codegroups.com/blog/index...-the-starting/

try this link

I hope this is help to you.

shailesh kavathiya