SQL Language (MOSC)

MOSC Banner

again, simple case statement

edited Feb 18, 2010 5:32AM in SQL Language (MOSC) 4 commentsAnswered
 I have this very simple case statemnt.  I've trying to ensure that all values are PNC for the campus column but I still values other than PNC.  I've checked and there are no null values in the campus column. Why isn't the case statement working?

SELECT person_uid,
            ID,
            campus,
            CASE
               WHEN campus IS NOT NULL
                   THEN  
                                 'PNC'
                   ELSE
                               'CAMPUS'
            END
               REPORTING_CAMPUS
       FROM frz_academic_study

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center