Jump to content

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?

Link to comment
Share on other sites


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

  • Create New...

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.