Try (not tested much)
DECLARE @InputNuber dec (7,2), @IntNumber int
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
--sb--