>Thank you Sergey. This does exactly what I need.
>
you're welcome and I think you can simplify it alittle bit

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