case statement in stored procedure

In MS SQL Server 2008, you can use a CASE statement to conditionally execute different program segments based on the value of a variable

DECLARE @NEW INT

-- Assign a value to the @NEW variable
SET @NEW = <your_value_here>

-- Use a CASE statement to execute different program segments based on the value of @NEW
CASE 
    WHEN @NEW < 40 THEN
        -- Program segment for when @NEW is less than 40
        -- Execute your program segment here
        
    WHEN @NEW >= 40 AND @NEW < 100 THEN
        -- Program segment for when @NEW is between 40 and 99
        -- Execute your program segment here
        
    WHEN @NEW >= 100 AND @NEW <= 500 THEN
        -- Program segment for when @NEW is between 100 and 500
        -- Execute your program segment here
        
    ELSE
        -- Program segment for all other cases
        -- Execute your program segment here
END;