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