How to delete decimals in sql server 2012

advertisements

I am getting a value in SQL server column like following:-

1667.7500000000000

Now i need to convert above value just like below value:-

1667

I want to remove .75 and also all zero's(i don't want to round it to 1668). Please anyone guide and share sample code.

Thanks in advance.


can you use a round transaction?

if so here ya go

ROUND ( numeric_expression , length [ ,function ] )