convert into number

Hi,
i have something like this in one of the columns
0.0416666666642413
0.0416666666642413
0.0833333333284827
0.0833333333284827
0.0833333333284827
0.0416666666642413

i would like to convert numbers like this:
4
4
8
8
4
how can i do this?
karinos57Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Multiply by 100, and cast it as an integer.  
SELECT CAST(YourNumber * 100 as int)

How did you want to handle rounding?
0
 
karinos57Author Commented:
tx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.