I need the command for cutting off decimals in a procedure

[Some1else]

Hey I'm wondering, what is the syntax for cutting off all decimals (not rounding) off a number? It's not FIX(), I have no clue what it could be but I guess it must be there. Also would this work if @NextLevel is declared as int or would @NextLevel/20 return an integer value as well?

IF @NextLevel/20=FIX(@NextLevel/20)

of course with FIX replaced by the appropriate command

Much appreciated

 

[Some1else]

nvm it's Round(num,0,1)

 

[4nntt]

Yes, two integers divided in SQL Server will return an integer result.
You need to cast the last one to a decimal, or just add .0 on the end:

IF @NextLevel / 20.0 = Round(@NextLevel / 20.0, 0, 1)

If you are checking if @NextLevel divides evenly by 20, you could also do this:

IF @NextLevel % 20 = 0

The % symbol in SQL Server is a 'mod' function, which divides two integers and returns the remainder only.