Thank you all for your quick responses

I finally made it work with your help

Ted

The field is numeric(5,4)

but you have something there.

would it be possible to move it to a char field and then apply the logic you gave me

Again, thank you so much...

Thanks for your prompt answer.

I was looking for something that would get rid of the decimal point

if the number was 10.73 or 10.733 or 10.7333 or 10.7

The decimal...

Will this code work in T-SQL or will I have to modify it

When I run it it I get the following error

Msg 156, Level 15, State 1, Procedure RemoveDecimalsWithoutRounding, Line...