T-Sql Remove Decimal Point From Money Data Type *

Question

Given the constraint of only using T-Sql in Sql Server 2005, is there a better way to remove the decimal point from a money datatype than a conversion to a varchar (here implicitly) and then a replace of the decimal point?

Here is what I have currently.

SELECT REPLACE(1.23, '.', ''), REPLACE(19.99, '.', '')

Which returns the desired 123 and 1999, but I was wondering if there was a better way. Any thoughts?

Answer

Multiply by 100 and then convert to an int.

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/3894/" >T-Sql Remove Decimal Point From Money Data Type< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.