title: In SQL How can I show a different value if some columns return ‘Y’, ‘N’ OR ‘L’,
body: <p>How can I show a different value if some columns return ‘Y’, ‘N’ OR ‘L’,
  for example,
  COLUMN "INACT_IND" returns ‘Y’, but I need show for the user ‘NOT ACTIVE’. Case ‘Y’, return ‘NOT ACTIVE’.</p>
  
  <p>I did a CASE function but it returned an error, my code is below:</p>
  
  <pre><code>select USR.LOGIN_ID, USR.NAME, "Active or Inactive" = (USR.INACT_IND), 
  "Created Date" = (USR.REC_CREATE_DATE)
  FROM USR
  where 
  CASE 
  WHEN USR.INACT_IND='N' THEN 'ACTIVE'
  WHEN USR.INACT_IND='Y' THEN 'NOT ACTIVE'
  WHEN USR.INACT_IND='L' THEN 'LOCKED'
  END
  </code></pre>