Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to take integer of a number?

Author  Topic 

jeff06
Posting Yak Master

166 Posts

Posted - 2007-05-22 : 15:53:29

for example which function can i use to convert the real number into the corresponding integers?

4.5 ->5
3.4->3
18.9->19
Thans

sshelper
Posting Yak Master

216 Posts

Posted - 2007-05-22 : 16:03:04
You can use the ROUND function for this.

SQL Server Helper
http://www.sql-server-helper.com
Go to Top of Page
   

- Advertisement -