Trim Decimals in money datatype

[essa2000]

Dears ;

I want to trim more decimal places of the money and save data with two decimals in the database and for showing also.

For example :

If there are amount 47.7584, I want to save it as 47.75 without rounding it off.

I also want to use these values in calculations after trim .

immediate Help is required !

essa2000

 

[Gundapaneni]

Delcare a variable with decimal datatype having scale 2 and assign the original value to newly declared variable.

DECLARE @result decimal(5,2),
@value1 decimal(5,4), @value2 decimal(5,4)
SET @value1 = 1.1004
SET @value2 = 1.0004
SELECT @result = @value1
SELECT @result
select @result=@value2
select @result

Madhu.

 

[essa2000]

Dear Madhu ;

I don't triming, but if we use these values then it also trims using your code ,

DECLARE @result decimal(5,2),
@value1 decimal(5,4), @value2 decimal(5,4)
SET @value1 = 1.1584
SET @value2 = 1.1874
SELECT @result = @value1
SELECT @result
select @result=@value2
select @result

I have found different solution and it works fine ,

IN SQL Server:
Floor function returns int part and this logic works fine

Select (floor(123.9987*100)/100)


In VB: in vb fix function does same ;

Debug.print fix(123.9987*100)/100)


Regards,
essa2000