Try (not tested much)

DECLARE @InputNuber dec (7,2), @IntNumber int

--SET @InputNuber = 297.99
SET @InputNuber = 299.91

SET @IntNumber  =  ROUND(@InputNuber, 0)

IF @IntNumber % 100 = 0 AND @InputNuber <> @IntNumber
	SELECT CAST(@InputNuber AS int)
	
ELSE
	SELECT @IntNumber

>
>I need to check if the number provided by user is breaking a hundred after rounding it up first. If that is a case it should be round down Ex:
>
>User input = 249.99 ; Suggested number = 250
>User input = 249.91 ; Suggested number = 250
>
>User input 299.99 ; Suggested number = 299
>User input 299.91 ; Suggested number = 299
>
>Thank you,
>Daniel