Conditional Display

i have an "active" field in the database that has the words "active" and "inactive" in it

how can i do i select, to only show Y and N, depending on the "act开发者_如何学Goive"/"inactive" wording in that field?

---

SELECT....
CASE WHEN Active = 'Active' THEN 'Y' ELSE 'N' END
....
FROM Table