Remove decimal with out rounding.

[kurangu]

Hi, I am using sql 2005.I have a value -0.026880000000000 but I want the result as -0.0268 just 3 decimals.If I use select convert(decimal(18,3),-0.026880000000000) I am getting -0.027 with rounded. can anybody help me out in this. Thx

[David Mujica]

Try this: a) Multiply the value by 1,000 b) Truncate the value c) Divide the number by 1,000 David

[kurangu]

HI, if i do like that select convert(decimal(18,3),(-0.0268000000000000000)*1000/1000) I am getting -0.027 which is again rounding.can you help me how to truncate the value with out rounding.

[Tim Carmichael]

select convert(int,convert(decimal(18,5),-0.026880000000000)*100000.0)/100000.0

[David Mujica]

I realize someone already replied, but here is my 2 cents ... select convert(decimal(18,3),(convert(integer,(-0.0268000000000000000)*1000)))/1000

[Blue_Boy]

DECLARE @val AS VARCHAR(255)
SET @val='-0.026880000000000'
SELECT SUBSTRING(@val,1,CHARINDEX('.',@val)+4)

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."

[PIEBALDconsult]

Use floor.