hi,

try this,

create table #temp

(

amount decimal(15,6)

)

insert into #temp

select 1245.658797

union

select 123597.599945

union

select 798754.589785

union

select 787561.124657

select substring((cast(amount as char)),0,(charindex('.',(cast(amount as char)))+3)) amount from #temp

amount

1245.65

123597.59

787561.12

798754.58

ARUN SAS