Using CASE

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

Below is an example of usingĀ CASE to Translate Cryptic Values into Meaningful Descriptions.

SELECT 

CASE currStatus 

WHEN 'A' THEN 'Active' 

WHEN 'I' THEN 'Inactive' 

WHEN 'P' THEN 'Pending' 

ELSE 'Obsolete' 

END AS 'Status',

courseSecCode AS 'Course Sec Code', 

secShortTitle AS 'Title' 

FROM course_sec;

 

Last Modified: May 9, 2015 @ 7:25 PM

Was this article helpful?

Related Articles