Function To Drop Decimal numbers 4

[Thuky]

Hi all,

Can anyone let me know what function to drop decimal numbers? For example the number is 200.75 and when I run my stored procedure, it should pull out only 200 (it will not pull out the decimal point and numbers after).

Thanks!!!

 

[amorous]

Try this:
Round(yournumber,0)

-VJ

 

[Thuky]

Thanks, amorous for your help!

 

[ESquared]

Round won't truncate the decimal portion, it will round.

So you may be looking for floor() (round downward) or ceiling() (round upward) as well.

 

[Glowworm27]

cant you just do a Convert(int, yournumber) ? this will take a decimal number and make it an integer

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[ESquared]

Convert works, too, depending on what you're doing with the number, but floor(number) is less typing.

 

[Thuky]

Thanks for all your helps. I am very appreciated.