How to delete decimals in sql server 2012


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


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


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 ] )