SQL issue with CASE expression
09:52 10 Mar 2015

I'm trying to adjust the following statement:

    SELECT CASE WHEN OrganizationLevel < 2 THEN UPPER(JobTitle)
           ELSE JobTitle END AS 'Job Title', COUNT(BusinessEntityID) AS 'number of employees'
    FROM HumanResources.Employee
    WHERE OrganizationLevel < 3 
    GROUP BY JobTitle, OrganizationLevel
    ORDER BY JobTitle ASC

I need to change it so as to make JobTitle appear as 'SOMETHING ELSE' when the OrganisationLevel is 1.

I thought this would be a simple matter of making a small change to the CASE expression so JobTitle would be = 'SOMETHING ELSE' but it won't allow me to do this.

sql sql-server sql-server-2012-express