Jump to content


This topic is now archived and is closed to further replies.


Use SQL to convert a float to integer?

Recommended Posts

This is my problem,

Have a MS SQL database with prices, like $ 1,50.
Now, can i get the $1,50 and remove the 0,50 so that i have a full number ( integer ) like instead of $1,50 - $1 with only the use of MS SQL?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.