Jump to content


Photo

Use SQL to convert a float to integer?


  • Please log in to reply
No replies to this topic

#1 Akira

Akira
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 24 May 2006 - 01:25 PM

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?


Greetz Akira





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users