Jump to content

Archived

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

Akira

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.